Update Method

See Also

Example

Applies To

OraDynaset

Description

Saves the copy buffer to the specified dynaset.

Usage

oradynaset.Update

oradynaset.DbUpdate

Remarks

Update completes an AddNew or Edit operation and immediately commits changes to the database unless BeginTrans is pending for the session.

Note that once you call Update on a given row in a dynaset in a global transaction (that is once you issue a BeginTrans), locks will remain on the selected rows until you call CommitTrans or Rollback.

The mirrored data image is also updated so that the query does not have to be reevaluated to continue browsing and updating data. The method used for updating the mirror image is subject to the options flag that was passed to the OpenDatabase that created this dynaset's OraDatabase object.

If this dynaset is attached to a data control, then the data control's Validate event code may optionally cancel the update request. If the update completes, then all bound controls associated with the dynaset are notified of the update so they can reflect the data changes automatically.