Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Delete - method of object AdoRecordset

Description:
Deletes a record in the AdoRecordset object. If not specified, then the current position record is selected.
Syntax:
Empty Delete([Long nAffectRecords])
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, in 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.
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:dynamic;");
if (oRs)
{
oRs.MoveFirst();
oRs.Delete();
}

History:
Pm8.01.00: Created
PROMOTIC 9.0.7 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