[sqlite] Hot journal file won't go away

2015-04-21 Thread Clemens Ladisch
Drago, William @ CSG - NARDA-MITEQ wrote: > What is the recommended procedure for clearing a hot journal file? Just opening the database should be enough. > I used to do a "SELECT..." but since I upgraded from System.Data.SQLite > 1.0.93.0 to 1.0.96.0 that doesn't work anymore. If the rollback o

[sqlite] Hot journal file won't go away

2015-04-21 Thread Drago, William @ CSG - NARDA-MITEQ
gt; users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Tuesday, April 21, 2015 4:30 PM > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Hot journal file won't go away > > Drago, William @ CSG - NARDA-MITEQ wrote: > > What is the

[sqlite] Hot journal file won't go away

2015-04-21 Thread Drago, William @ CSG - NARDA-MITEQ
All, What is the recommended procedure for clearing a hot journal file? I used to do a "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name" and "SELECT name FROM sqlite_master WHERE type='index' ORDER BY tbl_name" but since I upgraded from System.Data.SQLite 1.0.93.0 to 1.0.96.0