Page 1 of 1

SQLite - WAL journal mode

Posted: Wed 20 Feb 2019 14:21
by w.weiss
Hello!

How can I set the WAL journal mode in SQLite?
I wanted to use it in direct mode for any platform.

Re: SQLite - WAL journal mode

Posted: Thu 21 Feb 2019 16:10
by MaximG
The required parameter can be set in UniDAC using a special command SQLite PRAGMA : https://www.sqlite.org/pragma.html#pragma_journal_mode . For example :

Code: Select all

 UniConnection.ExecSQL('PRAGMA journal_mode=WAL');