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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
