Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Rolling back Transaction Doesn't Work with TpFIB Components


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jun 15, 2015 9:24 AM Last Post By: Dmitry Arefiev
Vishal Tiwari

Posts: 10
Registered: 3/27/10
Rolling back Transaction Doesn't Work with TpFIB Components  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 11, 2015 7:50 AM
Hi All,

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 ?
Code:

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
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Rolling back Transaction Doesn't Work with TpFIB Components  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 15, 2015 9:24 AM   in response to: Vishal Tiwari in response to: Vishal Tiwari
This forum is dedicated to FireDAC. Instead of asking here I will suggest to ask at:
* https://forums.embarcadero.com/forum.jspa?forumID=92
* https://forums.embarcadero.com/forum.jspa?forumID=84

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02