Devart Forums

Posted: **Thu 26 Aug 2010 08:18**

I have tried various names and valuesin the macros tab of the UniConnection but none seem to work

If I wanted to implement pragma journal_mode= WAL how would I go about it?

Posted: **Sat 28 Aug 2010 06:18**

Does this mean you cant do this?

Posted: **Mon 30 Aug 2010 14:23**

If you want to set the journal mode, you should execute the following SQL query:

Code: Select all

  PRAGMA journal_mode = WAL

in Delphi it can be executed by the following code:

Code: Select all

begin
  UniSQL1.SQL.Text := 'PRAGMA journal_mode = WAL';
  UniSQL1.Execute;
end;

To define a macro you can use the following code:

Code: Select all

  UniConnection1.MacroByName('a').Value := 'test';

You can find more detailed information about macros in the UniDAC help.

Posted: **Tue 31 Aug 2010 07:40**

Thanks bork

Devart Forums

passing pragma arguments to sqlite

passing pragma arguments to sqlite