Recent

Author Topic: Turing off Synchronous Mode in SQlite3  (Read 4342 times)

MainMeat

  • New Member
  • *
  • Posts: 18
Turing off Synchronous Mode in SQlite3
« on: April 20, 2009, 06:12:56 pm »
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!

 

TinyPortal © 2005-2018