How to start readonly transaction with TSQLConnection..

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
AndreyZ

Re: How to start readonly transaction with TSQLConnection..

Post by AndreyZ » 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.


respektive
Posts: 9
Joined: Wed 27 Nov 2013 00:09

Re: How to start readonly transaction with TSQLConnection..

Post by respektive » Fri 27 Dec 2013 14:27

It works fine in new version, thank you a lot.

Tom

AndreyZ

Re: How to start readonly transaction with TSQLConnection..

Post by AndreyZ » Fri 27 Dec 2013 15:35

You are welcome. If any other questions come up, please contact us.

respektive
Posts: 9
Joined: Wed 27 Nov 2013 00:09

Re: How to start readonly transaction with TSQLConnection..

Post by respektive » Thu 13 Feb 2014 10:41

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How to start readonly transaction with TSQLConnection..

Post by AlexP » Thu 13 Feb 2014 12:55

Hello,

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

respektive
Posts: 9
Joined: Wed 27 Nov 2013 00:09

Re: How to start readonly transaction with TSQLConnection..

Post by respektive » Thu 13 Feb 2014 12:57

Ok, thanks for info

so I have to wait :-(

Best regards, Tom

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Re: How to start readonly transaction with TSQLConnection..

Post by Dimon » Thu 13 Mar 2014 13:43

The new dbExpress driver for InterBase & Firebird build 4.3.5 is available for download.

aldi
Posts: 1
Joined: Wed 09 Jan 2019 13:40

Re: How to start readonly transaction with TSQLConnection..

Post by aldi » 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,

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?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How to start readonly transaction with TSQLConnection..

Post by ViktorV » Thu 10 Jan 2019 13:23

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';

Post Reply