I think he wants to know why he is receiving what appears to be an error notification via the callback.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Adam DeVita Sent: Thursday, June 28, 2012 9:05 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Not sure how to interrupt this 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
