It might be my implementation... it's custom for an embedded OS. Another item.. when having Journal Mode = PERSIST, DBA (in the example below) was not being physically updated. DBB was.
Simply taking out the PRAGMA fixed things. Any ideas where I should look? Marc -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Marc L. Allen Sent: Monday, December 17, 2012 2:18 PM To: General Discussion of SQLite Database (sqlite-users@sqlite.org) Subject: [sqlite] PERSIST Journal Mode I'm having some unexpected results using PRAGMA journal_mode = PERSIST; My general flow runs something like: open(DBA) PRAGMA journal_mode = PERSIST; ATTACH DBB SQL ... close() If the DBA.journal file exists, it's deleted before the attach (though I haven't identified exactly where. I can if important.) During the close, the DBA.mjxxxxx is deleted as is the DBB.journal file. The DBA.journal file is not deleted until the next time I open it. Am I misunderstanding something? Thanks, Marc -- ****************************************************************** * * * * Marc L. Allen * "... so many things are * * * possible just as long as you * * Outsite Networks, Inc. * don't know they're impossible." * * (757) 853-3000 #215 * * * * * * mlal...@outsitenetworks.com<mailto:mlal...@outsitenetworks.com> * -- The Phantom Tollbooth * * * * ****************************************************************** _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
