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 #54920 is a reply to message #54888]

Mon, 28 September 2020 20:33

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

Ok, ever onward Smile

I've created an sql file (attached) to generate a new database file.

Using this new db, and with dates from 1970 forward (epoch dates I believe), 5 digit ints.

Have dateconvert "borrowed" from sqlapp example "borrow.cpp". Dates show up perfectly in both tables and editdate controls.

Problem is, when I go to edit, I get assertion failure Sad

I delete contents and start with a number and ...

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

Attachment: example.png
(Size: 357.77KB, Downloaded 769 times)
Attachment: sample.sql
(Size: 46.31KB, Downloaded 296 times)

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: Tue Jul 14 19:44:22 GMT+2 2026

Total time taken to generate the page: 0.00623 seconds