SQLITE ODBC

[lucasdebeltran]

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.

[Marc Vanzegbroeck]

Hello,

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

[lucasdebeltran]

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

[Marc Vanzegbroeck]

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...

[lucasdebeltran]

Thank you.

And where I please find those diferences?.

[lucasdebeltran]

Marc,

And how do you deal with dates?-

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

Thanks.

[nageswaragunupudi]

Mr Lucas

You can make it simple if you use FWH13.05

Code: Select all | Expand

#include "fwsqlcmd.ch"

...........

cSql := SQL INSERT INTO bestand (DATA), VALUES ( Date() ) 
// The above is translated into the syntax that SQL Server understands
// if you like you can examine by ? cSql
oCn:Execute( cSql )

 

[Marc Vanzegbroeck]

Marc,

And how do you deal with dates?-

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

Thanks.

You have to transform the date to 'YYYY-MM-DD'

Code: Select all | Expand

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' )+'"'