Peter Aronson wrote: > a SAVEPOINT command fails with an open statement handle used to > execute PRAGMA journal_mode = off at SQLite 3.8.0, but appears to > succeed at SQLite 3.7.17. This does not appear to be documented.
<http://www.sqlite.org/lang_transaction.html> says: | An implicit transaction (a transaction that is started automatically, | not a transaction started by BEGIN) is committed automatically when | the last active statement finishes. A statement finishes when its | prepared statement is reset [sqlite3_reset] or finalized | [sqlite3_finalize]. So you are still inside the implicit transaction. > Note that a BEGIN TRANSACTION will appear to succeed where the > SAVEPOINT appears to fail. It is not documented what happens when you try to mix explicit and implicit transaction, but it's not a good idea anyway. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
