Mike Goins <mike.go...@adtecservices.net> wrote: > I use BEGIN TRANSACTION and COMMIT as prepared statements in a C > application. I originally was not resetting these types of > non-binding prepared statements that only return SQLITE_DONE. > > http://www.sqlite.org/c3ref/step.html states: > SQLITE_DONE means that the statement has finished executing > successfully. sqlite3_step() should not be called again on this > virtual machine without first calling sqlite3_reset() to reset the > virtual machine back to its initial state. > > I don't seem to be having problem not resetting while reusing the > statements/connection
Are you checking return value from sqlite3_step? I suspect your calls are actually failing, and your subsequent statements are not bound by an explicit transaction. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users