On December 31, 2004 06:37 am, D. Richard Hipp wrote: > Thomas Fjellstrom wrote: > > It is possible for result items to sit around un finalized for a period, > > would that cause sqlite to keep a table locked? > > In version 3.0.5 and earlier, the commit did not occur until you > ran sqlite3_finalize(). Beginning with version 3.0.6, the commit > occurs on the last call to sqlite3_step() - the one that returns > SQLITE_DONE. > > Even in version 3.0.8, if you have a query running on a table > that has not yet returned SQLITE_DONE, then you are prohibited > from making changes to that table.
so something as simple as: -- Thomas Fjellstrom [EMAIL PROTECTED] http://strangesoft.net