Hi,
I have a nested transaction as follows - sqlite3_prepare_v2(db, stmt1..) sqlite3_prepare_v2(db, stmt2..) sqlite3_step(stmt1) sqlite3_step(stmt2) sqlite3_reset(stmt2) sqlite3_step(stmt1) (1) SQLITE , as I understand does not support nested transaction, hence the the above statement should have caused error (2) A transaction is complete only when sqlite3_reset is called. Hence the sqlite3_step(stmt2) should have returned a "database locked" error. However,the above statements succeed if stmt1 is a read and stmt2 is a write. Is SQLITE doing something under the hood ? (like upgrading the locks for ex ). -Regards, Sreekumar _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
