Re: [sqlite] what is the default for the commit when the connection is opened.

Thank a lot Jay From: Jay A. Kreibich To: General Discussion of SQLite Database Sent: Wednesday, April 8, 2009 1:22:57 PM Subject: Re: [sqlite] what is the default for the commit when the connection is opened. On

Re: [sqlite] what is the default for the commit when the connection is opened.

On Wed, Apr 08, 2009 at 10:12:15PM +0200, Martin Engelschalk scratched on the wall: > Hi, > > sqlite does not know an "auto commit". Actually, that's what the default mode is called. You're either in "autocommit" mode or you're in a transaction. Starting a transaction turns off

Re: [sqlite] what is the default for the commit when the connection is opened.

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

[sqlite] what is the default for the commit when the connection is opened.

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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users