Recent

Author Topic: What is the correct way to change journal mode with zeos  (Read 1422 times)

Stygian

  • Jr. Member
  • **
  • Posts: 90
What is the correct way to change journal mode with zeos
« on: July 27, 2016, 11:31:58 am »
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][+][-]
  1.   ZConn1.Connected := False;
  2.   ZConn1.Database := 'database location';
  3.   ZConn1.Properties.Clear;
  4.   ZConn1.Properties.Add('AutoEncodeStrings=ON');
  5.   ZConn1.Properties.Add('journal_mode=PERSIST');
  6.   ZConn1.Properties.Add('controls_cp=cCP_UTF8');
  7.   ZConn1.Properties.Add('codepage=UTF-8');
  8.   ZConn1.Connect;

Thank You,
Sty

 

TinyPortal © 2005-2018