Applies To
ODynaset
OBinder
Description
This method saves dynaset changes to the Oracle database.
Usage
oresult Update(void)
Remarks
For ODynaset, Update is the end of the three-part record editing sequence:
Call StartEdit.
Change field values, either with SetFieldValue or SetValue.
Call Update.
Calling Update saves to the Oracle database the changes that have been made. If you are in
the middle of a transaction (that is, your session had BeginTransaction called on it), the changes are not made permanent until a Commit is done. Alternatively, the changes can be canceled with a Rollback.
For OBinder, Update saves any changes that have been marked in the current record. This results
in the same behavior as ODynaset::Update.
ODATABASE_ORAMODE determines precisely what happens to values of fields that
have not been explicitly set. See ODatabase for details.
Calling Update sends OADVISE_UPDATE messages to all advisories attached to the dynaset. If
the dynaset is being managed by an OBinder object, PreUpdate and PostUpdate triggers are called.
Note that once you call Update on a given row in a dynaset in a global transaction (i.e. once you issue a
BeginTrans), locks will remain on the selected rows until you call commit the
transaction or rollback.
Return Value
An oresult indicating whether the operation succeeded (OSUCCESS) or not
(OFAILURE).
Example
This example sets the salary in the current record to $9985.
// we have a dynaset named empdyn
// edit the salary
empdyn.StartEdit();
empdyn.SetFieldValue("salary", 9985.0);
empdyn.Update();