Home » U++ Library support » U++ SQL » sqlite and dropdate / editdate etc (Can you receive an integer value and display as date?)
Re: sqlite and dropdate / editdate etc [message #54908 is a reply to message #54899] |
Mon, 28 September 2020 14:19   |
 |
mirek
Messages: 14257 Registered: November 2005
|
Ultimate Member |
|
|
jimlef wrote on Sat, 26 September 2020 18:16I do that a lot Mirek 
I am testing things out, I added a field TESTING to my products table. I added a Testing editdate to the layout for editing prodcuts.
When I save a testing date to my database, it's stored as yyyy-mm-dd, while my region is supposed to put year last. I'd like to use my region to manage the format, as that would make the code more generally usable (for later sharing).
OK, that one is unexpected This would require changing Sqlite3 code module. I can do that, but I am really not sure this is a good idea; as these text are basically internal format, maybe the most logical internal format is indeed yyyy-mm-dd. Apart from being ISO 8601 conformant, it at least can be sorted correctly... From broader perspective, this is not what user will see, this is basically only issue for admin and I think most admins would be more comfortable with ISO...
Quote:
When I reload the info into my editdate field, the field is colored light red... doesn't that indicate invalid value?
Yes. If you would call Accept for that dialog (that basically happens on normal OK button, more generaly on all "acceptor" buttons), it would display error and return false.
Mirek
|
|
|
 |
|
sqlite and dropdate / editdate etc
By: jimlef on Fri, 25 September 2020 07:19
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Fri, 25 September 2020 08:18
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Fri, 25 September 2020 08:30
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Sat, 26 September 2020 15:10
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Sat, 26 September 2020 18:16
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Mon, 28 September 2020 14:19
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Mon, 28 September 2020 15:59
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Fri, 25 September 2020 23:37
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mr_ped on Sat, 26 September 2020 04:28
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Sat, 26 September 2020 07:43
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Mon, 28 September 2020 17:41
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Mon, 28 September 2020 17:49
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Mon, 28 September 2020 18:06
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Mon, 28 September 2020 18:51
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Mon, 28 September 2020 20:33
|
 |
|
Re: sqlite and dropdate / editdate etc
By: mirek on Mon, 28 September 2020 22:51
|
 |
|
Re: sqlite and dropdate / editdate etc
By: jimlef on Tue, 29 September 2020 00:51
|
Goto Forum:
Current Time: Sat May 10 18:55:30 CEST 2025
Total time taken to generate the page: 0.00738 seconds
|