Hello,
If I attach one or more databases and wrap a series of operations
which affect some/all of them, would ROLLBACK or COMMIT treat these
operations atomically? For example:
Open database 'foo';
Attach database 'bar' as a1;
BEGIN TRANSACTION;
INSERT INTO main.some_table ... ;
DELETE FROM main.some_table WHERE ... ;
INSERT INTO a1.another_table ... ;
COMMIT/ROLLBACK TRANSACTION;
Would the insertions and deletions be either committed or rolled back
atomically? Is this supported?
Thanks,
-- Tito
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
