Promotic
WikipediaLinkedInYoutubeTwitterFacebook

RecordCount - property of object AdoRecordset

Description:
Returns the number of records in the AdoRecordset object.
Syntax:
RecordCount As Long
Calling:
n = oRs.RecordCount
Note:
Property access for read only. In case of error and if the number of records check is not supported, returns the -1 value. This property is not supported, for example, when using the "forwardonly" cursor, see PmaAdo.RsOpen method.
See also:
Example:
Detects the number of records in the AdoRecordset object, over the PmaAdo object ("/TestAdoDb"), that is currently connected to the database (see DbOpen), by the SQL query ("SELECT * FROM table1").
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:static;");
var nCount;
if (oRs)
nCount = oRs.RecordCount;

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