Re: [sqlite] Transaction across different DB handles returns SQLITE_INTERNAL

2008-10-20 Thread John Belli
On Mon, 20 Oct 2008 18:01:03 + (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

Re: [sqlite] Transaction across different DB handles returns SQLITE_INTERNAL

2008-10-20 Thread Igor Tandetnik
MikeW <[EMAIL PROTECTED]> wrote: > I presume I'm not allowed to do this: > > // apply updates on first db - start Transaction > ret = sqlite3_exec( >first_db, >"BEGIN; UPDATE " FIRST_DB_TABLE >" SET " FIRST_DB_COLUMN "=1 " >