Page 2 of 2

Re: How to start readonly transaction with TSQLConnection..

Posted: Fri 20 Dec 2013 14:01
by AndreyZ
Sorry, that was my mistake. I will send you a custom build on Monday, to the email address specified in your account.

Re: How to start readonly transaction with TSQLConnection..

Posted: Mon 23 Dec 2013 06:58
by AndreyZ
Sent.

Re: How to start readonly transaction with TSQLConnection..

Posted: Fri 27 Dec 2013 14:27
by respektive
It works fine in new version, thank you a lot.

Tom

Re: How to start readonly transaction with TSQLConnection..

Posted: Fri 27 Dec 2013 15:35
by AndreyZ
You are welcome. If any other questions come up, please contact us.

Re: How to start readonly transaction with TSQLConnection..

Posted: Thu 13 Feb 2014 10:41
by respektive
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

Re: How to start readonly transaction with TSQLConnection..

Posted: Thu 13 Feb 2014 12:55
by AlexP
Hello,

The latest version of dbExpress driver for InterBase & Firebird is 4.3.4. We plan to release the next build this month.

Re: How to start readonly transaction with TSQLConnection..

Posted: Thu 13 Feb 2014 12:57
by respektive
Ok, thanks for info

so I have to wait :-(

Best regards, Tom

Re: How to start readonly transaction with TSQLConnection..

Posted: Thu 13 Mar 2014 13:43
by Dimon
The new dbExpress driver for InterBase & Firebird build 4.3.5 is available for download.

Re: How to start readonly transaction with TSQLConnection..

Posted: Wed 09 Jan 2019 14:16
by aldi
Hello,
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;
- not workimg,

and

Code: Select all

SQLConnection1->BeginTransaction(5)
return

Code: Select all

---------------------------
Debugger Exception Notification
---------------------------
Project MyApp.exe raised exception class TDBXError with message 'unknown ISC error 0'.
---------------------------
Break   Continue   Help   
---------------------------
How to make read-only transaction?

Re: How to start readonly transaction with TSQLConnection..

Posted: Thu 10 Jan 2019 13:23
by ViktorV
aldi wrote: Wed 09 Jan 2019 14:16 Hello,
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;
- not workimg,
This code won't work due to the reasons specified in the first posts of this topic.
and

Code: Select all

SQLConnection1->BeginTransaction(5)
return

Code: Select all

---------------------------
Debugger Exception Notification
---------------------------
Project MyApp.exe raised exception class TDBXError with message 'unknown ISC error 0'.
---------------------------
Break   Continue   Help   
---------------------------
How to make read-only transaction?
To solve the problem, please try to specify the exact path to the client library of your Firebird. For example:

Code: Select all

SQLConnection1.Params.Values['VendorLib']: = 'C:\Program Files\Firebird\Firebird_3_0\fbclient.dll';