Roberto Padovani wrote:
Now, about assumptions.
in sqlite3ds there is the assumption that BOOLEAN fields are stored as
1 or 0. In fact, to recover a db that had "TRUE" and "FALSE", I made a
new class where I changed ftBool to fString. In this way I could read
them, parse them and then write them
Luca Olivetti wrote:
En/na Roberto Padovani ha escrit:
When the project I'm working on is finished, I'll strip everything
from the source code and only leave a detailed tutorial for using
sqlite without visual components.
FWIW to do that you can also use sqlite3 directly (or with a thin
wrap
En/na Roberto Padovani ha escrit:
When the project I'm working on is finished, I'll strip everything
from the source code and only leave a detailed tutorial for using
sqlite without visual components.
FWIW to do that you can also use sqlite3 directly (or with a thin
wrapper), you don't have t
Now, about assumptions.
in sqlite3ds there is the assumption that BOOLEAN fields are stored as
1 or 0. In fact, to recover a db that had "TRUE" and "FALSE", I made a
new class where I changed ftBool to fString. In this way I could read
them, parse them and then write them back as 1 or 0.
With the
Hi Luiz,
first of all, thanks a lot for the good job you did with sqlite for us all!
> > So, now my app can understand a timestamp field as a TDateTime instead
> > of a string...
>> ..
>>[removed]
>>...
>
> Here's how sqlite works (for good and bad):
>
> - You can create tables with any "field ty
En/na Luiz Americo Pereira Camara ha escrit:
- Try sqlitepass and sqldb/sqlite3. I vaguely remenber of sqlitepass to
support timestamp. I don't know about sqldb.
Note that sqlitepass is windows only (at least it was last time I looked).
You can also use zeos, it is cross platform but I didn't
Roberto Padovani wrote:
Hi all!
two things: 1) a (possible) improvement to sqlite3ds; 2) the old
problem with dates and time
1) I found a sqlite database that uses the TIMESTAMP data type, but
this is not directly supported by the Tsqlite3Dataset written by Luiz.
I added the if-else checks in s
Hi all!
two things: 1) a (possible) improvement to sqlite3ds; 2) the old
problem with dates and time
1) I found a sqlite database that uses the TIMESTAMP data type, but
this is not directly supported by the Tsqlite3Dataset written by Luiz.
I added the if-else checks in sqlite3ds.pas for this type
Hi all!
two things: 1) a (possible) improvement to sqlite3ds; 2) the old
problem with dates and time
1) I found a sqlite database that uses the TIMESTAMP data type, but
this is not directly supported by the Tsqlite3Dataset written by Luiz.
I added the if-else checks in sqlite3ds.pas for this type