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