On 4/20/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Nicholas Bastin <[EMAIL PROTECTED]> > wrote: > > When trying to commit a transaction, I'm getting the following error > > message from sqlite3_exec(): > > > > "cannot commit transaction - SQL statements in progress" > > > > Is there any way to find out what statements are in progress? Also, > > what could cause this? I can guarantee that sqlite3_step has returned > > SQLITE_DONE on all my statements before I get to this point. Is that > > not sufficient? > > No, it is not sufficient. You have to sqlite3_reset or sqlite3_finalize > all statements in progress before you can commit.
Ok, thanks. I'll make sure to reset all statements before trying to commit the transaction. (Is this mentioned somewhere in the documentation?) -- Nick