StyveA <styve.at...@technicolor.com> wrote: > For the COMMIT/END point, I though that sqlite_prepare(..) was sufficient > to do it, so Begin is mandatory?
Prepare doesn't touch the database in any way. It just parses the text of the statement, and prepares execution plan. Step is where the real work is done. You need to issue BEGIN statement if you want to start an explicit transaction (and then COMMIT or END to commit it, or ROLLBACK to roll it back). If you don't, then each individual statement executes in its own implicit transaction, which automatically starts when you first call sqlite3_step, and commits when you call sqlite3_reset or sqlite3_finalize (or rolls back if the statement fails). -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
