How to manage multiple transactions with Firedac?

Asked

Viewed 718 times

2

Greetings.

I have a Tfdconnection and would like to have two Tfdtransactions in my project.
Tfdconnection is not connected to any Transaction, only Transactions are connected in Connection. Only Tfdquery is connected in Connection and also in one of Transactions.
After being given an UPDATE with Fdquery and a COMMIT in Transaction the information is not commited in the database.
Now the question: WHY?

Details:

  • Banco: Firebird;
  • IDE: Delphi XE7;
  • Note: Before UPDATE I give a Starttransaction in Tfdtransaction and on final, a commit.

Grateful.

  • Theoretically, what you said is correct. It would have to post something of your code to check?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.