On Sunday 08 August 2004 6:26 pm, D. Richard Hipp wrote: > Scott Leighton wrote: > > Whenever you start a SELECT statement (by calling sqlite3_step()) but have > not finalized that statement (using sqlite3_finalize() or sqlite3_reset()) > the statement is probably holding a lock on the table(s) that are being > queried. Other SELECT statements can read those tables, but no other > statements can INSERT, UPDATE or DELETE those tables until after all the > SELECTs have been finalized.
Once again, thank-you! That makes complete sense and explains exactly what I am seeing. You are a lifesaver, I was really struggling with this, now I have a lead to solve it! Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.5-7.104-default x86_64
