Re: How to start readonly transaction with TSQLConnection..
Posted: Fri 20 Dec 2013 14:01
Sorry, that was my mistake. I will send you a custom build on Monday, to the email address specified in your account.
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
procedure TMainForm.BitBtnClick(Sender: TObject);
var
tr: TTransactionDesc;
begin
SQLConnection.Open;
tr.IsolationLevel := xilCUSTOM;
tr.CustomIsolation := 1; // flag that transaction is read-only
SQLConnection.StartTransaction(tr);
end;
Code: Select all
SQLConnection1->BeginTransaction(5)
Code: Select all
---------------------------
Debugger Exception Notification
---------------------------
Project MyApp.exe raised exception class TDBXError with message 'unknown ISC error 0'.
---------------------------
Break Continue Help
---------------------------
This code won't work due to the reasons specified in the first posts of this topic.aldi wrote: ↑Wed 09 Jan 2019 14:16 Hello,
I use RAD Studio 10 Seattle, and can't make read-only transactions
- not workimg,Code: Select all
procedure TMainForm.BitBtnClick(Sender: TObject); var tr: TTransactionDesc; begin SQLConnection.Open; tr.IsolationLevel := xilCUSTOM; tr.CustomIsolation := 1; // flag that transaction is read-only SQLConnection.StartTransaction(tr); end;
To solve the problem, please try to specify the exact path to the client library of your Firebird. For example:andreturnCode: Select all
SQLConnection1->BeginTransaction(5)
How to make read-only transaction?Code: Select all
--------------------------- Debugger Exception Notification --------------------------- Project MyApp.exe raised exception class TDBXError with message 'unknown ISC error 0'. --------------------------- Break Continue Help ---------------------------
Code: Select all
SQLConnection1.Params.Values['VendorLib']: = 'C:\Program Files\Firebird\Firebird_3_0\fbclient.dll';