Hi, sqlite does not know an "auto commit". If you do not call "begin transaction", then every insert/update/delete statement is wrapped in its own transaction. This is like "auto commit" If you do call "begin transaction", you start a transaction which you have to finish with "commit" or "rollback". This does not depend on how you open the database.
Martin Joanne Pham wrote: > Hi All, > When we use the sqlite3_open_v2 to open the database is this defautl to "Auto > commit" ? > Thanks, > JP > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

