Rob Richardson wrote:
Put single quotes around Testitem:
sprintf( sqlquery, INSERT INTO tblTest ( CINDEX, CDATE, CDESCR, CAMOUNT
) VALUES ( 5, 2012-08-29, 'Testitem', 300 ));
And around cdate too. There are no dedicated date type in sqlite, 2012-08-
29 is
treated as expression ((2012 -
Hello all,
I started to experiment with SQLite3. I created database with
rc = sqlite3_exec(m_db, CREATE TABLE [tblTest] ( [CINDEX] INTEGER
PRIMARY KEY, [CDATE] DATE, [CDESCR] TEXT, [CAMOUNT] NUMERIC), callback, 0,
zErrMsg);
Then I added some items into table with sqlitebrowser_200.