Visual Basic: RDO Data Control

Visual Studio 6.0

MaxRows Property (Remote Data)

See Also    Example    Applies To

Returns or sets a value indicating the maximum number of rows to be returned from a query or processed in an action query.


object.MaxRows [= value]

The MaxRows property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A Long expression as described in Settings.


The setting for value ranges from 0 to any number. If value is set to 0, no limit is placed on the number of rows returned (default). Setting value to a negative number is invalid and is automatically reset to 0.


The MaxRows property limits the number of rows processed by the remote server. When MaxRows is set to a value greater than 0, only 'n' rows are processed. When executing a query that returns rows, it means that only the first 'n' rows are returned. When executing an action query, it means that only the first 'n' rows are updated, inserted or deleted.

This property is useful in situations where limited resources prohibit management of large numbers of result set rows. By setting MaxRows to 1 on an action query, you can be assured that no more than one row will be affected by the operation.