确定SQLite3事务是否处于活动状态-DetermineifSQLite3transactionisactive

10  

You might want to check this:

你可能想检查一下:

http://www.sqlite.org/c3ref/get_autocommit.html

According to the page, if you are in a transaction, sqlite3_get_autocommit() will return 0.

根据页面,如果您在事务中,sqlite3_get_autocommit()将返回0。

0  

In SQLite, transactions created using BEGIN TRANSACTION ... END TRANSACTION do not nest.

在SQLite中,使用BEGIN TRANSACTION ... END TRANSACTION创建的事务不会嵌套。

For nested transactions you need to use the SAVEPOINT and RELEASE commands.

对于嵌套事务,您需要使用SAVEPOINT和RELEASE命令。

See http://www.sqlite.org/lang_transaction.html

and http://www.sqlite.org/lang_savepoint.html

0  

That's weird. I thought sqlite was always in a transaction, either explicitly created by you or implicitly created by sqlite:

那真是怪了。我认为sqlite总是在一个事务中,要么由你明确创建,要么由sqlite隐式创建:

http://www.sqlite.org/lang_transaction.html

So I suppose the error means that it's not in a transaction that you initiated ... and if that's what you need to know, it seems OK for sqlite to expect you to keep up with it. Not terribly convenient of course, but I guess that's the cost of a simple API. =/

所以我认为错误意味着它不在你发起的事务中...如果这是你需要知道的,那么sqlite似乎可以期待你跟上它。当然不是非常方便,但我想这是一个简单的API的成本。 = /