Transactions

Zdenek Vasku · Post by **Zdenek Vasku** » Wed 05 Sep 2007 17:37

Hello,

I'm a little newbie to firebird and dbxida. Now I'm using Oracle for all my work (dbxoda). For small customers I decided to user Firebird with minimal change to the source code. I'm using TClientDataset-TDatasetProvider-TSqlQuery or TSqlQuery only. In oracle I'm doing this:

query
query
start transaction
apply updates
commit or rollback
query
query
etc

This works ok. I need only one transaction for update data at time.
But if I use the same code for Firebird (2.0.1) I have got 'Can't perform operation on inactive transaction' or 'transaction must be explicitly specified'. I have read that if no transaction is specified code uses last opened. I don't wont to overwrite all sqls to specify transaction etc. If I set TransactionLevel on query, dbxida dll hangs on AccesViolation.

What is wrong in my code?
Thanks
Zdenek

Challenger · Post by **Challenger** » Thu 06 Sep 2007 10:58

Please send to DbxIda support address a small sample that demonstrates this problem.