Delete - method of object AdoRecordset
Deletes a record in the AdoRecordset
object. If not specified, then the current position record is selected.
|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 (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, over the PmaAdo
object ("/TestAdoDb"), that is already connected to the database (see DbOpen
), 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;");