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