Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Delete - method of object AdoRecordset

Description:
Deleting a record in the AdoRecordset object If not specified the corrent position record is selected.
Syntax:
Delete([nAffectRecords As Long])
Calling:
oRs.Delete nAffectRecords
Parameters:
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).
Note:
After deleting a record, the deleted record remains current until you move to a different record.
See also:
Example:
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.
Dim oDb, oRs
Set oDb = pMe.Pm("/TestAdoDb")
Set oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:dynamic;")
  oRs.MoveFirst
  oRs.Delete
End If
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice