I am having the "cannot commit transaction - SQL statements in progress" issue.
I have read through the mailing list and cannot find a solution to my problem. My problem: I am running, through some prepared statements (with single threaded code) a select statement, an insert statement, a select statement, and finally an insert statement. Every 100 times thru this logic, I commit and begin a new transaction. The odd thing is that this works several times in a row and then will fail with the above error. I am sure that I am calling sqlite_reset() for each statement that I execute. I am using sqlite version 3.6.1 on Mac OS X 10.5.4. Any ideas of what could be going on? Thanks, Tom _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
