On 31 Jan 2012, at 5:16pm, Bill McCormick wrote: > So when I run an update command (to update some arbitrary record) from the > sqlite3 command line, do I need to do something to do a checkpoint?
Iff you fail to open a transaction before you do a SQL command, SQLite will automatically wrap it in its own transaction, as follows: BEGIN; <whatever your command was> END; This takes care of automatic checkpointing for you. If you want to do checkpointing, rollback, or other such SQL commands yourself, go ahead and do them. They'll work. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users