LockTimeout: Extended DBExpress Configuration
Posted: Mon 27 Jul 2020 18:22
Hi, all fine?
I have a little doubt about LockTimeout configuration.
In Readme file, have this description:
About this, follow the questions:
1) Is possible configurate this extented option in TSQLConnection default from Delphi?
Example:
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.
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);
1) Is possible configurate this extented option in TSQLConnection default from Delphi?
Example:
Code: Select all
SQLConnection1.Params.Values['LockTimeout'] := '5000';
3) To DevartInterBase TransIsolation option, what values are allowed?
Thanks.