When working with very large or unfamiliar databases, you may occasionally process a query that takes a long time to run or returns more data than is manageable. To prevent problems under these conditions, set query options before processing.
To set query options:
Select the desired restrictions for the current query and click OK.
Return Unique Rows—Eliminates duplicate rows from the data set retrieved by the query. It is not a regression. If the data source for a query is a local results table, even though this feature is enabled, the Unique Rows filter is not enforced.
Return First ___ Rows—Filters the number of database rows retrieved to the number entered.
Time Limit ___ Minutes—Filters the amount of time the query is allowed to run to the number entered. Seconds are entered as a decimal number. Time filters work for asynchronous database connections and cancel at the earliest opportunity for nonasynchronous connections.
Auto Process—Specifies the current query as a Standard Query to be processed automatically on download from the Repository (Designer only).
Custom Group By—Customizes the Group By criteria used to compute aggregate Request items, with selected items not factored into the grouping. This feature is available only when a data function is placed on a Request item.