FiveTech Support Forums

Hello,

I am testing SQLite to be use with ADO.

I found this ODBC driver:

http://www.ch-werner.de/sqliteodbc/

Anyone is using it?.

Or another ODBC driver?.

Thank you very much.

Hello,

I'm using it.
It's working very nice.

Marc,

What string for connection do you use?.

Also, have you found any particular issue?.

For example, I discover that function MONTH is not supported:

SELECT * FROM APUNTES WHERE MONTH(FECHA) = '1'

Any comment will be welcomed.

Thank you.

Best regards

Lucas,

As connectionstring I use:
Driver={SQLite3 ODBC Driver};Database=c:\temp\test.db;

Database=c:\temp\test.db is the SQlite-file.

I didn't use month in SQlite, but you can use something like FECHA>... AND FECHA< ...

There are indeed difference between MySQL and SQLite functions and syntax...

Thank you.

And where I please find those diferences?.

Marc,

And how do you deal with dates?-

INSERT INTO bestand (DATA), VALUES DTOC(DATE()) shows nill on the record,

Thanks.

lucasdebeltran wrote:Marc,

And how do you deal with dates?-

INSERT INTO bestand (DATA), VALUES DTOC(DATE()) shows nill on the record,

Thanks.

INSERT INTO bestand (DATA), VALUES sqldate(DATE()) 

FUNCTION sqlddate(vdatum)
RETURN '"'+PadL(  Year( vdatum), 4, '0' )+'-'+PadL( Month( vdatum), 2, '0' )+'-'+PadL(   Day( vdatum), 2, '0' )+'"'