Re: [sqlite] Re: INSERT after creating an INDEX

[Frank Fiedler]

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

[Igor Tandetnik]

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]
-