Delete - method of the AdoRecordset object
Deletes a record in the AdoRecordset
object. If not specified, then the current position record 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) The records that comply with the filtering criteria (the "Recordset.Filter" property).
After deleting a record, the deleted record remains current 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.
oDb = pMe.Pm("/TestAdoDb");
oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:dynamic;");