Page 1 of 1

Can I use the same structure of my components that already work with Firebird and also use with Postgres?

Posted: Mon 23 Nov 2015 20:47
by soyjoy
Hi,
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;
Thanks very much for atention.

Re: Can I use the same structure of my components that already work with Firebird and also use with Postgres?

Posted: Tue 24 Nov 2015 07:01
by azyk
We have tried to reproduce the problem according to your recommendations, but it wasn't reproduced. Please compose a small test sample reproducing the problem and send it to andreyz*devart*com .