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
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
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
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
Mail list logo