On 22 Jan 2011, at 1:27am, James Berry wrote: > - Delete src.db, tmp.db, dst.db > - Copy a static copy of my database (src.db) to a well-known temporary > place (tmp.db). > - Make some changes to the database (add some indexes, etc) > - If everything has succeeded, copy tmp.db -> dst.db
Between steps 3 and 4 I hope you close the connection to the database. Apart from that, I suggest you add some logic to look for the journal file before step 4 and generate an error message if one still exists. Apart from that I see no problem with your procedure. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
