Delete - method of object AdoRecordset
Deleting a record in the AdoRecordset
object. If not specified, then the current position record is selected.
Delete([nAffectRecords As Long])
|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 PmAdo
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.
VBScriptSelect and copy to clipboard
Dim oDb, oRs
Set oDb = pMe.Pm("/TestAdoDb")
Set oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:dynamic;")
If Not oRs Is Nothing Then