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.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
