nbpost and commit

[bmayfield]

It has been awhile, DOA has just been running fine. We think we have a problem where we update a column with a value of N to Y in a dbgrid and we click a save button. The code behind the save button is as follows:

procedure TFRIQ0024frm.btnSaveClick(Sender: TObject);
begin

if (not TOracleDataSet(onAll.DataSource.DataSet).QBEMode)
and (onAll.DataSource.DataSet.State in [dsEdit, dsInsert]) then
begin
onAll.BtnClick(OracleNavigator.nbPost);
FRIQ0024frm.stbStatusLine.Panels[1].Text :=
'Changes have been saved'

end;

Doesn't DOA do a commit of all outstanding changes to the database as part of nbpost functionality?

Regards,

Bruce M.

 

[Marco Kalter]

A Post operation will commit the session's transaction if:

• TOracleDataSet.CachedUpdates is set to False (the default value).
• TOracleDataSet.CommitOnPost is set to True (also the default value).

 

[bmayfield]

Thanks.

Bruce