Hi Dennis Cote, But how do we read the current synchronous value using C interface. Plz reply.
Regards Jayanth On Mon, 16 Oct 2006 Dennis Cote wrote : >jayanth KP wrote: >> 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. >> >> >> > >The pragma commands are documented at http://www.sqlite.org/pragma.html. To >check the current value simply execute a "pragma synchronous" command. The >current setting will be returned. In your case it should be 2 for FULL >synchronous operation. > >The SQLITE_NO_SYNC flag is a define that can be passed to the compiler while >buiding your code. Look in your makefile or your compiler's options setting >dialog for -DSQLITE_NO_SYNC. > >HTH >Dennis Cote > >----------------------------------------------------------------------------- >To unsubscribe, send email to [EMAIL PROTECTED] >----------------------------------------------------------------------------- >