RowsRead Property

Object List Next Object

Defined By: Recordset

Description:

Indicates number of Records in the underlying Database referred to by this Recordset.

Details:

If the underlying database is created from connecting to an ASCII text file, the total number of rows or lines of data in the file will be displayed here. If the FirstRowAsFieldNames property is set to True, the RowsRead property will automatically be adjusted by 1.

If the underlying database is created from an ODBC relational database source, the total number of rows or records of data will not be displayed here unless the MoveLast method is executed. This is because the RecordSet object does not load the entire contents of a database when it first connects. Rows are read as they are called for by the application.

Data Type: Long (Read Only)