Progress
Results User’s Guide
for Windows


Using the Data Governor

The Data Governor is an option that limits the number of records a query displays. By default, when you run a query, Results displays all the records in the selected tables that meet the display and data selection criteria. However, the Data Governor allows you to save time and system resources by displaying only a specific number of records. For example, if you have 10,000 orders, you might want to limit the number shown to 30 while you develop and test the query. This allows Results to process 30 orders instead of 10,000 orders when you print or preview the query.

For example, if you run a query that displays the customer name and balance, Results displays all the customers in the selected tables. You can use the Data Governor to display only the first 20 records.

You can only use the Data Governor in the Report, Label, and Export views.

Follow these steps to use the Data Governor:

  1. Choose Data Governor. The Data Governor dialog box appears:
  2. Enter the number of records you want to display.
  3. Activate the Include in Generated Code toggle box if you want to include this limit in the generated code.
  4. This means that when you run the query from an application, Results displays only the number of records specified in the Number of Records field. If you do not activate this toggle box, Results displays all the records when you run the query from an application.

  5. Choose OK.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095