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 the RsOpen method.
See also:
Example:
Detecting the number of records in the AdoRecordset object, over the PmAdo object ("/TestAdoDb"), that is currently connected to the database (see DbOpen), by the SQL query ("SELECT * FROM table1").
Dim oDb, oRs, nCount
Set oDb = pMe.Pm("/TestAdoDb")
Set oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:static;")
  nCount = oRs.RecordCount
End If
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice