Hi All, I am not sure whether this question is suitable here or not, but still I would like to give a try.
I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction and TpFIBDataset with Firebird database. I have already set TpFIBDataset's 'AutoCommit' property to 'False', then also when I execute below statement in the try..finally block and rollback the transaction data still get posted. Could anyone help ? FIBDataset.Post; Below is the sample code. try FIBDatabase.StartTransaction; .... Block of Code; FIBDataset.Post; ... finally if saveALL then FIBDatabase.CommitRetaining else FIBDatabase.RollbackRetaining; end; With Best Regards. Vishal