Sorry for the late reply. I never use sqlite3_prepare() or sqlite3_prepare16(), but I do use Prepare16. Thanks, Michael J. Leaver 2BrightSparks Pte Ltd http://www.2BrightSparks.com/ -----Original Message----- From: yunqa-bounce@xxxxxxxxxxxxx [mailto:yunqa-bounce@xxxxxxxxxxxxx] On Behalf Of Delphi Inspiration Sent: 20 July 2009 15:40 To: yunqa@xxxxxxxxxxxxx Subject: [yunqa.de] Re: SQLite Error 1 - not an error. 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 _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa