Hi there, I would like to confirm the transaction flow for three SQL statements (2 INSERT's + 1 UPDATE): sqlite3_open_v2() - open database sqlite3_prepare_v2() - prepare a statement sqlite3_step() - BEGIN TRANSACTION if an error occured sqlite3_finalize() sqlite3_reset() - reset prepared statement sqlite3_step() - INSERT if an error occured previously for INSERT (skip the UPDATE) else sqlite3_reset() - reset prepared statement sqlite3_step() - UPDATE end if an error occured previously for either INSERT or UPDATE (skip the INSERT) else sqlite3_reset() - reset prepared statement sqlite3_step() - INSERT end sqlite3_reset() - reset prepared statement if an error occured previously for either INSERT or UPDATE OR INSERT sqlite3_step() - ROLLBACK TRANSACTION else sqlite3_step() - COMMIT TRANSACTION end sqlite3_finalize() - open database sqlite3_close() - close database Is this the correct flow? Thank you very much. Regards, David
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users