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])
oRs.Delete 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 (Recordset.Filter property).
After deleting a record, the deleted record remains current until you move to a different record.
See also:
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
End If
PROMOTIC 8.3.30 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice