Hi there, I would just like to confirm that this is the processing flow for a transaction made of two SQL statements (INSERT + UPDATE): sqlite3_open_v2() - open database sqlite3_prepare_v2() - prepare statement sqlite3_step() - BEGIN TRANSACTION using above prepared statement sqlite3_reset() - reset prepared statement sqlite3_step() - INSERT .... sqlite3_reset() - reset prepared statement sqlite3_step() - UPDATE .... (if there were errors returned during any of the INSERT or UPDATE operations) sqlite3_step() sqlite3_finalize() - finalize prepared stament Thank you very much. Regards, David
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users