[sqlite] Journal file not getting deleted

2006-11-24 Thread mithin
Hi, In my application I am using SQLite 3 c++ API. Everything works fine till my application is open. While doing any transaction a journal file is created. Once I close the app, the journal file is not getting deleted. Also, when I close open the application again, all the newly added data is

Re: [sqlite] Journal file not getting deleted

2006-11-24 Thread Lloyd
Are you forgetting to close the database? On Fri, 2006-11-24 at 02:03 -0800, mithin wrote: Hi, In my application I am using SQLite 3 c++ API. Everything works fine till my application is open. While doing any transaction a journal file is created. Once I close the app, the journal file is

Re: [sqlite] Journal file not getting deleted

2006-11-24 Thread mithin
Thanks for replying. Here is what I do Open Database int err = 0; sqlite3_stmt *ppStmt; if(sqlite3_open(dbPath.toUtf8().data(),db) != SQLITE_OK){//It opens the database correctly sqlite3_close(db); db = 0; return false; } //set the restore point //I thought this could

Re: [sqlite] Journal file not getting deleted

2006-11-24 Thread mithin
I have figured out where the problem is In one place I forgot to call sqlite3_finalize(ppStmt); Anyways, thanks a lot for your time. Thanks once again. mithin wrote: Thanks for replying. Here is what I do Open Database int err = 0; sqlite3_stmt *ppStmt;