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

2007-09-13 Thread 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

Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hi Simon, On 3.4.2 built from amalgamation on XP using Visual Studio I can follow your scenario without problems. I used command line shell and tcl shell. More detail will help (version etc). Ok...let's try the next level of detail: - We are using sqlite 3.4.0 on linux (Redhat Enterprise

[sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hello everybody, 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). I have the following setup: - I have two processes accessing a single sqlite data base. process1