U++ forum: Welcome to the forum

Re: Date emulation for Sqlite [message #5295 is a reply to message #5293]

Tue, 12 September 2006 20:33

mirek
Messages: 14264
Registered: November 2005

Ultimate Member

zsolt wrote on Tue, 12 September 2006 12:28

My problem with this special double is that it would break two things:
1. Internal sqlite date operations as Ulti pointed to that
2. the readability of the result of a simple sql select.

I don't know well the logic of sch files yet, but wouldn't it be possible to use them to get the type of a column?

1. can be to large degree solved by SqlExp. In fact, it is "timestamp" type in disguise...

2. OK, this has not come to my mind, that is valid concern. OTOH, it affects non-U++ tools only. In U++, you would be able to get correct dates only.

What about to be a little crazy and encode Date(2006, 9, 12) as 0.20060912e300 ? Smile

Anyway, any other ideas how to store Date into Sqlite?

The only other one that I have is to store it as string with prefix - that however would mean to introduce some trouble to regular strings as well.

Well, I guess I owe the reason why that is so important. The thing to solve is that you cannot now with Sqlite associate EditDate with Sqlite column. Especially troublesome with SqlCtrls or SqlArray.

Mirek

Report message to a moderator