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
delphiman
Posts: 4
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

LockTimeout

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

const
  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?

Example:

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?


Thanks.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: LockTimeout: Extended DBExpress Configuration

Post by oleg0k » Thu 11 Mar 2021 14:19

Hello, Sorry for not getting back to you sooner, we had a glitch in our support ticket system. Does the issue still exist?

delphiman
Posts: 4
Joined: Mon 27 Jul 2020 18:11

Re: LockTimeout: Extended DBExpress Configuration

Post by delphiman » Thu 11 Mar 2021 16:47

Hello Oleg, all right.
No, the situation is already cleared up. All very well.
Thank you very much.

Best Regarts.

Post Reply