d_maniger06 <d_maniger06-/[EMAIL PROTECTED]> wrote:
i have a list of records that i want to insert in my database..if
ever an error occurred ( e.g. insert was not successful ), i want to
undo all the previous inserts that i have done..to do this, i have
read that i would need to use sqlite3_commit_hook and
sqlite3_rollback_hook..
No, you don't need anything of the kind. Just issue a BEGIN statement at
the beginning, then all your insert statements. If everything succeeded,
issue a COMMIT statement at the end, otherwise issue a ROLLBACK
statement. See
http://sqlite.org/lang_transaction.html
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
