Matthew Vanecek wrote: > A question....: does SQLite support transactional updates (e.g., multiple > updates rolled into one BEGIN/COMMIT block)? >
Yes. All changes between a BEGIN and COMMIT are atomic - either they all occur or none of them occur. This is true even if the update is interrupted by a program crash, an OS crash, or a power failure.
If you do a BEGIN then a bunch of updates/deletes/inserts then change you mind, you can always do a ROLLBACK instead of a COMMIT to restore the database to its state right before the BEGIN.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
_______________________________________________ gnucash-devel mailing list [EMAIL PROTECTED] http://www.gnucash.org/cgi-bin/mailman/listinfo/gnucash-devel
