Setting Limits on the Number of Records Retrieved

You can set a limit on the number of records retrieved when a statement is executed in the Statement Builder. A default limit is set to 1000 records. If you want this limit to be applied to the statement when it is executed in a client display, you must select the Apply this Max to SQL Statement check box on the Statement Options tab. The number that is specified in the Max number of records retrieved box will then be applied as a limit when the statement is used as a data source for an object.

See Also

To set limits on the number of records retrieved