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

Reply via email to