On Mon, 20 Oct 2008 18:01:03 +0000 (UTC), MikeW <[EMAIL PROTECTED]> wrote:
>Still, I would like to be able to run the Transaction over these two calls ... >What's the best way, given I have two separate handles ? >Make them separate Transactions and do a ROLLBACK on the first if the >second exec fails, possibly ? Tht might work. You could also look into ATTACH DATABASE syntax (the proper way to maintain atomicity between databases) http://www.sqlite.org/lang_attach.html Attach the 2nd database before beginning the transaction. JAB -- John A. Belli Software Engineer Refrigerated Transport Electronics, Inc. http://www.rtelectronics.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users