Page 1 of 1

LockTimeout: Extended DBExpress Configuration

Posted: Mon 27 Jul 2020 18:22
by delphiman
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.

Re: LockTimeout: Extended DBExpress Configuration

Posted: Thu 11 Mar 2021 14:19
by oleg0k
Hello, Sorry for not getting back to you sooner, we had a glitch in our support ticket system. Does the issue still exist?

Re: LockTimeout: Extended DBExpress Configuration

Posted: Thu 11 Mar 2021 16:47
by delphiman
Hello Oleg, all right.
No, the situation is already cleared up. All very well.
Thank you very much.

Best Regarts.