Turing off Synchronous Mode in SQlite3
lazarus / 16-Databases

----------------------------------------------------------------------
MainMeat · 2009-04-20 16:12

Hi All,

Does anyone know how to turn off the synchronous mode in sqlite3? I am
trying to execute 'PRAGMA synchronous = OFF; from a lazarus
application using TSQLite3Dataset but it does not seem to update the
sync status of SQLite, but it also does not return an error. For
example:

Code: [Select]   SQLDataset.SQL := 'pragma synchronous = off;';
   SQLDataset.ExecSQL'
   SQLDataSet.SQL := 'pragma synchronous;';
   SQLDataSet.open;

   Writeln('PRAGMA SYNC VALUE IS : ', SQLDataset.fields[0].asString);


The above always returns the value of '1' which is the "normal" state,
and no matter what I change it to, I cannot get it to accept anything
else.

Any ideas?

Thanks!