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.
#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 )
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' )+'"'
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: Enrico Maria Giordano, Google [Bot] and 38 guests