How to start readonly transaction with TSQLConnection..
Re: How to start readonly transaction with TSQLConnection..
Sorry, that was my mistake. I will send you a custom build on Monday, to the email address specified in your account.
-
- Posts: 9
- Joined: Wed 27 Nov 2013 00:09
Re: How to start readonly transaction with TSQLConnection..
It works fine in new version, thank you a lot.
Tom
Tom
Re: How to start readonly transaction with TSQLConnection..
You are welcome. If any other questions come up, please contact us.
-
- Posts: 9
- Joined: Wed 27 Nov 2013 00:09
Re: How to start readonly transaction with TSQLConnection..
Dear Andrey,
please would you be so kind and send me the full version of dbExpress driver.
We bought the driver on 13th January (company KP-SYS)
But official downloads doesnt enable to download version 4.3.5 - there is 4.3.4 from october only.
Or can you upload new version for official download??
My demo version licence is over and I can't work!!
Thank you in advance
Tom
please would you be so kind and send me the full version of dbExpress driver.
We bought the driver on 13th January (company KP-SYS)
But official downloads doesnt enable to download version 4.3.5 - there is 4.3.4 from october only.
Or can you upload new version for official download??
My demo version licence is over and I can't work!!
Thank you in advance
Tom
Re: How to start readonly transaction with TSQLConnection..
Hello,
The latest version of dbExpress driver for InterBase & Firebird is 4.3.4. We plan to release the next build this month.
The latest version of dbExpress driver for InterBase & Firebird is 4.3.4. We plan to release the next build this month.
-
- Posts: 9
- Joined: Wed 27 Nov 2013 00:09
Re: How to start readonly transaction with TSQLConnection..
Ok, thanks for info
so I have to wait
Best regards, Tom
so I have to wait
Best regards, Tom
Re: How to start readonly transaction with TSQLConnection..
The new dbExpress driver for InterBase & Firebird build 4.3.5 is available for download.
Re: How to start readonly transaction with TSQLConnection..
Hello,
I use RAD Studio 10 Seattle, and can't make read-only transactions
- not workimg,
and
return
How to make read-only transaction?
I use RAD Studio 10 Seattle, and can't make read-only transactions
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;
and
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
---------------------------
Re: How to start readonly transaction with TSQLConnection..
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';