U++ framework: U++ SQL » sqlite and dropdate / editdate etc

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 :: Polls :: Message Navigator
E-mail to friend

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

Mon, 28 September 2020 17:41

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

Upon further inspection, it seems that the ctrls Convert functions scan the field data, and interpret as string or int, never DATE_V (since sqlite doesn't have an official 'date_v' type). So, date formatting isn't applied. I guess what I need is a concise way to tell the function that this field should be interpreted as qtype date_v? Then make sure that the data in that field is appropriate for that type.

Report message to a moderator

[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) ] [

] [

]

Current Time: Mon Jul 13 17:19:33 GMT+2 2026

Total time taken to generate the page: 0.02597 seconds