Found a very informative post here: http://forums.devart.com/viewtopic.php? ... ing#p94977 essentially what I was running into while using Rollback.
Changing to RollbackRetaining fixed some but brought up another issue. Now if a deletion occurred and was rolled back the Table does not show the record until refreshed, I actually used the undocumented RefreshQuick(True) method.
This brings up a Q; is there a way to enum all the datasets affected by RollbackRetaining?
Essentially they all need to be refreshed, or am I missing a setting somewhere?
thanks
Fred
Fb Transactions and RollbackRetaining
Re: Fb Transactions and RollbackRetaining
Yes, after calling the RollbackRetaining method you should call Refresh on needed datasets manually. The RollbackRetaining method will affect those datasets, which Transaction property points to the TUniTransaction component, for which the RollbackRetaining method was called.