Teg <[EMAIL PROTECTED]> wrote:
I had a bit of a breakthrough. Apparently compiled selects sqlite3_prepare_v2 that live longer than the transaction are enough to prevent the transaction from commiting. Each thread has it's own connection to the DB.
You don't have to finalize all statements, it's sufficient to sqlite3_reset them (and then you can use them in a new transaction without re-preparing). But yes, all outstanding statements must be reset or finalized before you can commit a transaction.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
