Number of rows in a result set.

Defined in

ODBCResultSet

Syntax

num% = odbcResultSet.NumRows

Return value

num%

Number of rows in the result set.

You can determine the number of rows only after the entire result set is fetched, not immediately after a query or while fetching records. You can immediately determine whether the result contains any rows at all; 0 is a valid value for this property.

This property is DB_NORESULT if there is no result set; DB_ROWSUNKNOWN if the number of rows is not known; DB_ROWSLIMITED if MaxRows limits the number of rows.

If a memory shortage causes truncation of the result set, IsEndOfData is True on the last row but NumRows is still DB_ROWSUNKNOWN.

Events

BeforeNumRows

AfterNumRows

Example
See Also

CurrentRow property
IsEndOfData method
IsResultSetAvailable method
LastRow method
LocateRow method
MaxRows property
NextRow method

Glossary