Hello Michael J. Leaver, >I'm fighting fires at the moment so don't currently have the time to create >a test case. I can say that if I downgrade from V2.0.8 to V2.0.7 then the >bug disappears, so the problem does appear to be with indexing in V2.0.8. Could the sqlite3_prepare() vs. sqlite3_prepare_v2() problem apply, as discussed here: //www.freelists.org/post/yunqa/schema-error,5 If yes, could you please replace calls to sqlite3_prepare() with sqlite3_prepare_v2() and calls to sqlite3_prepare16() with sqlite3_prepare16_v2() and see if this helps? Ralf _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa