Hi Richard, Thanks for ur reply. I searched in the whole source code i could not find SQLITE_NO_SYNC flag.
Also i tried the following in my c code, after sqlite_open() was success. sqlite_exec(pDbHandle,"PRAGMA synchronous=FULL;", NULL, NULL, &pErrMsg); Even this did not seem to work. How do i check if this PRAGMA is working fine from my code. Please help me in solving this issue Regards Jayanth On Fri, 13 Oct 2006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > Hi Richard, > > > > We are ALREADY using sqlite 2.8.13. > >Your original post said you were using 2.8.3. Must have >been a typo. > > > > > OBSERVATIONS: > > ------------- > > > > 1) If i call sync() system call after database update, the database is not > > getting corrupted. > >SQLite calls sync() twice during each COMMIT, unless you have >it disabled. My guess is that you must be doing > > PRAGMA synchronous=OFF; > >Or perhaps you are compiling with -DSQLITE_NO_SYNC=1. > >-- >D. Richard Hipp <[EMAIL PROTECTED]> > > >----------------------------------------------------------------------------- >To unsubscribe, send email to [EMAIL PROTECTED] >----------------------------------------------------------------------------- >