Delete Method

See Also

Example

Applies To

OraDynaset

Description

Deletes the current row of the specified dynaset.

Usage

oradynaset.Delete

oradynaset.DbDelete

Remarks

A row must be current before you can use Delete; otherwise an error occurs.

Note that once you call Delete 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 CommitTrans or Rollback.

Any references to the deleted row produce an error. The deleted row, as well as the next and previous rows, remain current until database movement occurs (using the MoveFirst, MovePrevious, MoveNext, or MoveLast methods). Once such movement occurs, you cannot make the deleted row current again.

You cannot restore deleted records except by using transactions.

Note: A call to Edit, AddNew, or Delete, will cancel any outstanding Edit or AddNew calls before proceeding. Any outstanding changes not saved using Update will be lost during the cancellation.