Re: [sqlite] Re: INSERT after creating an INDEX
Hi Igor, All prepared statements become invalid when the database schema changes. You need to finalize your statement and prepare it again. Alternatively, if you are using new enough version of SQLite, use sqlite3_prepare_v2 to prepare your statements: it stores the original query string and automatically re-prepares the statement when schema changes. You are absolutely right, thanks for the hint! This solved indeed the problem. Have a nice day, Frank. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: INSERT after creating an INDEX
Frank Fiedler <[EMAIL PROTECTED]> wrote: I have a problem inserting elements into a data base (from process1 accessing the data base) after creating an INDEX on a table (from another process accessing the data base). The error I get is the following: "SQLITE_ERROR : SQL logic error or missing database" All prepared statements become invalid when the database schema changes. You need to finalize your statement and prepare it again. Alternatively, if you are using new enough version of SQLite, use sqlite3_prepare_v2 to prepare your statements: it stores the original query string and automatically re-prepares the statement when schema changes. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -