Hi All,
I have read the sqlite document and document stated that:
The SQL command "COMMIT" does not actually commit the changes to disk. It
just turns autocommit back on.
The question is the default of database open connection is "autocommit" and if
my function has :
sqlite3_exec(pDb,"BEGIN;", NULL, 0, &errMsg);
sqlSt = sqlite3_step(pStmt);
..........
sqlSt = sqlite3_exec(pDb,"END;", NULL, 0, &errMsg);
Then Do I need to sqlSt = sqlite3_exec(pDb,"COMMIT;", NULL, 0, &errMsg) to
turn on the autocommit again.
Thanks
JP
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
