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.