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;
>
> 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 be the culprit and commented it but the problem is
> not here
> //err = sqlite3_exec(db,"BEGIN TRANSACTION RESTOREPOINT;",NULL,NULL,NULL);
> //if (err != SQLITE_OK) {
> //error
> //}
>
> Close Database
>
> if (db){
> //I thought the following line might be the cause of problem and
> therefore commented it.
> //But commenting this did not solve the problem
> //if ( SQLITE_OK != sqlite3_exec(db,"COMMIT TRANSACTION
> RESTOREPOINT;",NULL,NULL,NULL) ) {
> //Error Message
> //}
> int err = sqlite3_close(db);//err is 0
> }
>
>
> I am not able to figure out where the problem is.
>
> Please help
> Thanks a lot
>
--
View this message in context:
http://www.nabble.com/Journal-file-not-getting-deleted-tf2697588.html#a7524384
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
