On 4/26/2013 7:18 PM, Igor Korot wrote:
If I'm inside transaction and want to insert a record, will I see right after executing sqlite3_step() or I have to execute a "COMMIT" statement to see it?
The connection that executed sqlite3_step() would see its own changes right away. Other connections would only see changes after they've been committed. This is "I" in ACID.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users