Hello all, Many years ago, Igor mentioned that you should always reset/finalize any prepared statements before calling COMMIT.
I am wondering, is this still true? I have prepared SELECTs and INSERTs which have been step()'d, but not reset. the SELECTs tend to be stepped until there is no more data left, but that may not be guaranteed in the future. Do I have to reset before I commit? And where is the requirement written in the sqlite documentation? thanks, Paul ----- OLD EMAIL --------- Dec 15, 2008; 9:39pm Re: COMMIT in SQLite "hussainfarzana" <[hidden email]> wrote in message news:[hidden email] > We have used BEGIN and COMMIT while executing our statements.While > executing the BEGIN the return value is 0,but for COMMIT its > returning 1. COMMIT is failing. Without seeing your code, it's hard to know why. One possible reason is that you still have open statements. Make sure to sqlite3_reset or sqlite3_finalize all open statement handles before executing COMMIT. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
