Page 1 of 1

Connection InTransaction Always True after opening Query?

Posted: Fri 21 Feb 2014 12:22
by Brob
Hi
I'm connecting to a firebird/Interbase database and opening a TUniQuery containing a simple select statement. In the past I've always used UniQuery.Connection.InTransaction as one of the methods to check if any changes may have been made or are in progress. But this always seems to be true as soon as the TUniQuery is opened!

Am I doing something wrong?
Rad Studio 2007 Unidac Version 5.2.5

Re: Connection InTransaction Always True after opening Query?

Posted: Wed 14 May 2014 15:17
by PavloP
The InTransaction property of the TUniConnection component returns the default transaction status. The specificity of the Firebird server is that an open dataset always requires an active transaction. If you don't assign a separate TUniTransaction component for a dataset, then the dataset will use the default transaction of its TUniConnection component.
For actions modification, you can use a separate transaction and check its status.