SQLITE DONE is what you get when you successfully run an insert. What is the problem? Adam
On Wed, Jun 27, 2012 at 7:02 PM, Jeff Archer <jarch...@yahoo.com> wrote: > I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement > is clearly being executed. > > SQL: "INSERT INTO [Scans](ScanID, Timestamp, EndTime, Result) VALUES(NULL, > @Timestamp, @Timestamp, @Result);" > > The table has been created as: > CREATE TABLE [Scans] > (ScanID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT > ,Timestamp DATETIME NOT NULL UNIQUE > ,EndTime DATETIME NOT NULL DEFAULT CURRENT_TIME > ,Result VARCHAR > ); > CREATE INDEX Scans_vwScan_Index on Scans(ScanID, Timestamp, EndTime, > Result); > CREATE INDEX Scans_Timestamp_Index on Scans(Timestamp); > > I have SQLITE_CONFIG_LOG callback installed: > sqlite3_config(SQLITE_CONFIG_LOG, cb_sqlite_config_log, /*pUserData*/NULL); > > I get the following message through the SQLITE_CONFIG_LOG callback during > the sqlite3_step(): > errcode: SQLITE_SCHEMA (17) > message: statement aborts at 80: [INSERT INTO [Scans](ScanID, Timestamp, > EndTime, Result) VALUES(NULL, @Timestamp, @Timestamp, @Result);] database > schema has changed > > SQLITE_VERSION "3.7.13" - amalgamation > > Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 151 Whitehall Dr, Unit 2 Markham ON, L3R 9T1 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users