Turing off Synchronous Mode in SQlite3

[MainMeat]

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!