Transactions
Posted: 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
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