[sqlite] Transaction across different DB handles return s SQLITE_INTERNAL

[MikeW]

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 "
                    " WHERE " FIRST_DB_COLUMN " NOT NULL;",
                     NULL, NULL, NULL));
// returns SQLITE_OK

// delete updates from second db - commit Transaction
ret = sqlite3_exec(
                    second_db,
                    "UPDATE " SECOND_DB_TABLE 
                    " SET " SECOND_DB_COLUMN "= NULL "
                    " WHERE " SECOND_DB_COLUMN " NOT NULL; END;",
                     NULL, NULL, NULL));
// returns SQLITE_INTERNAL

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 ?

Thanks,
MikeW

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users