Got the answer in the below link.
http://stackoverflow.com/questions/30781212/rolling-back-transaction-doesnt-work-with-tpfib-components?noredirect=1#comment49820919_30781212
Solution:
I would also advise you to allocate the one transaction component to all the
datasets (rather than the
Hi Helen, Hi All,
I have one issue with the transaction, let me explain in detail what is
happening...
I am using Delphi 2010 with FIB Plus components ( TpFIBDatabase,
TpFIBTransaction and TpFIBDataSet ), and Firebird as database.
Case 1:
I have an existing customer's database, on which Commit