LockTimeout: Extended DBExpress Configuration

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
Posts: 1
Joined: Mon 27 Jul 2020 18:11

LockTimeout: Extended DBExpress Configuration

Post by delphiman » Mon 27 Jul 2020 18:22

Hi, all fine?
I have a little doubt about LockTimeout configuration.

In Readme file, have this description:

Code: Select all


Use this option to set the Lock timeout for WAIT transactions available on Firebird 2.1 and higher.

  coLockTimeout = TSQLConnectionOption(403); // integer
. . .
  SQLConnection1.SQLConnection.SetOption(coLockTimeout, 10);
About this, follow the questions:

1) Is possible configurate this extented option in TSQLConnection default from Delphi?


Code: Select all

SQLConnection1.Params.Values['LockTimeout'] := '5000';
2) The value from LockTimeout is what? Miliseconds? Seconds? This information not exists in Readme File.

3) To DevartInterBase TransIsolation option, what values are allowed?


Post Reply