U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » sqlite and dropdate / editdate etc (Can you receive an integer value and display as date?)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: sqlite and dropdate / editdate etc [message #54913 is a reply to message #54908]

Mon, 28 September 2020 15:59

jimlef is currently offline

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

The internally stored format is irrelevant to me, as whatever format the program expects can be used (and converted to)...

Then only 1 issue remains. I have here two dropdate ctrls, auto loading from sqlctrls functions.

They retrieve the stored iso date and show it as stored ie 2020-03-15. They then mark it as invalid, and pop an
error if you try to store a new date in that format. The same holds true for EditDate, naturally.

Shouldn't they show dates in the current locale format? When I drop the calendar and click on a date,
the new date is shown correctly, at least for my locale. With EditDate, when I type in manually 03-15-2020 or
even using / instead, it is accepted. But why doesn't it show in that mode initially? I think it is failing to
parse the date info, and will try stepping through to verify.

index.php?t=getfile&id=6232&private=0

index.php?t=getfile&id=6232&private=0

Attachment: example.png
(Size: 271.09KB, Downloaded 515 times)

Report message to a moderator

Send a private message to this user

[Message index]

		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

Previous Topic:	How does All_Tables determine if a table exists?
Next Topic:	Program changing column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 10 18:52:35 CEST 2025

Total time taken to generate the page: 0.04975 seconds