My Firebird structure is as follows:
UniConnection [AutoCommit = False]> UniTransaction
UniQuery> UniTransaction
The application can either work with Firebird, as in PostGres, but when I run the query.execute get an error like this:
Can not perform operation on inactive transaction.
And that is so in the application:
Code: Select all
try
try
UniQuery.Transaction := UniTransaction;
UniTransaction.DefaultConnection := connPostgreSQL;
UniTransaction.StartTransaction;
UniQuery.Execute;
ShowMessage('Ok');
except
on e: exception do
mmErro.Lines.Add(e.Message);
end;
finally
UniTransaction.Rollback;
end;