Read-write. Maximum number of rows fetched to the result set, or 0 to fetch all rows subject to memory limits.

Defined in

ODBCResultSet

Data type

Long

Syntax

To get: rows& = odbcResultSet.MaxRows

To set: odbcResultSet.MaxRows = rows&

Usage

This parameter defines a subset of the data. You can use MaxRows to limit the number of rows to be processed while developing a script.

Example
See Also

CacheLimit property
FetchBatchSize property
LastRow method
NextRow method
NumRows method

Glossary