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?
(Is it better to compile a statement that says COMMIT and use
sqlite3_step, rather than sqlite3_exec ("COMMIT")? )
--
Nick
