Delete - method of the AdoRecordset object
Deletes record in the AdoRecordset
If not specified, then the current record position is selected.
Empty Delete([Long nAffectRecords])
|nAffectRecords||[optional](Long) The value of the ADO AffectEnum type defines which records are to be deleted.
1 (default) - (adAffectCurrent) Current record.
2 - (adAffectGroup) Records that comply with the filtering criteria (the "Recordset.Filter" property).
After deleting a record, the deleted record remains current record until you move to a different record.
Setting the first record as the active record position, in the PmaAdo
), that is already connected to the database (see the DbOpen
method), by the SQL
query ("SELECT * FROM table1"
). It is followed by deleting the active record.
var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:dynamic;");