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.
(Is it better to compile a statement that says COMMIT and use
sqlite3_step, rather than sqlite3_exec ("COMMIT")? )
It won't make any difference.
Igor Tandetnik
