Is there a way to ensure that a Zeoslib sqlite database is opened
read only?
lazarus / 16-Databases

----------------------------------------------------------------------
vfclists · 2016-03-31 22:58

What settings can I use to ensure that a Sqlite database opened in
Zeoslib will not interfere with the ability of another process to read
from it?

I think that is something that should be set in the TZConnection
properties. Is there some option or something in the parameters that
will ensure that another process needing to write to the same database
will not be blocked?

----------------------------------------------------------------------
lazjump · 2016-04-01 00:16

Perhaps you could use the query_only pragma
(http://sqlite.org/pragma.html#pragma_query_only).

After connecting to the database, do something like this:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ZConnection1.ExecuteDirect('PRAGMA query_only=ON;');