What is the correct way to change journal mode with zeos
lazarus / 16-Databases

----------------------------------------------------------------------
Stygian · 2016-07-27 09:31

Hello,

I have a database on a server where all the users have different
rights. Some of the don't have rights to delete the journal file.

What is the correct way to change it in zeoslib?

I tried this but i think its not worked:
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  
ZConn1.Connected := False;  ZConn1.Database := 'database location'; 
ZConn1.Properties.Clear; 
ZConn1.Properties.Add('AutoEncodeStrings=ON'); 
ZConn1.Properties.Add('journal_mode=PERSIST'); 
ZConn1.Properties.Add('controls_cp=cCP_UTF8'); 
ZConn1.Properties.Add('codepage=UTF-8');  ZConn1.Connect;
Thank You,
Sty