RowLimit (Property)

Applies To:

QuerySection object, DataModel object

Description:

Defines the maximum number of rows retrieved by queries against the Data Model. Use this property with RowLimitActive (Property) to define the maximum number of rows to retrieve. This property corresponds to the Rows field on the General tab of the Data Model Options dialog.

Action:

Read-Write, Number

Example:

This example shows how to define a 100 row limit and process the query:

ActiveDocument.Sections["Query2"].DataModel.RowLimitActive = true
ActiveDocument.Sections["Query2"].DataModel.RowLimit = 100
ActiveDocument.Sections["Query2"].Process()