Cached updates

[panda]

How it is possible to only post cached updates to the database WITHOUT commit or rollback ?

 

[Marco Kalter]

Call TOracleSession.ApplyUpdates and pass False to the Commit parameter. An example from the help file:

procedure TDeptForm.ApplyButtonClick(Sender: TObject);
begin
  // Apply the changes and do not yet commit
  Session.ApplyUpdates([DeptDataSet], False);
  // Perform some checks and commit or rollback accordingly
  if DeptEmpValid then
    Session.CommitUpdates([DeptDataSet])
  else
    Session.Rollback;
end;