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
Connection InTransaction Always True after opening Query?
Re: Connection InTransaction Always True after opening Query?
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.
For actions modification, you can use a separate transaction and check its status.