Progress
Results User’s Guide
for UNIX


Query Module Main Menu

A horizontal menu appears at the top of each window throughout your query process as shown in Figure 4–2.

Figure 4–2: Query Module Main Menu

In some cases you see a subset of these options. For example, you might only see the options you can pick when there is a subset of information in the current form.

Table 4–1 provides a brief description of each option in the Query module. For complete descriptions, see "Option Descriptions." If you do not have all the options listed here, see your database administrator.

Table 4–1: Query Module Main Menu Options
Menu Option
Description
Next
Finds the next record in the file or subset according to the current active index and selection criteria. For example, if the records are in order by customer number, the customer number is the current index. In that case, Next finds the record with the next highest customer number. If you are in a subset of a file, Next finds the next record in the subset. (Use the Order option to change the way the forms are ordered.)
Prev
Finds the previous record in a file or subset.
First
Finds the first record in a file or subset.
Last
Finds the last record in a file or subset.
Add1
Adds a new record to the file using the current form (if you have permission). For example, you can add a new customer record if the customer form is on your display. If you select this option when you have two or more files joined, the Add window provides default information that you can keep or modify.
Update1
Updates the currently displayed record (if you have permission). For example, Update enables you to change the address for a customer who has moved.
Copy1
Copies the currently displayed record to a new record (if you have permission). Lets you copy the record displayed in the window to create a new record, and then update the new record’s contents.
Delete1
Deletes the currently displayed record (if you have permission).
View
Selects another query form to view. For example, if you are looking at customer records, you can use View to select a different kind of form to look at, such as sales order records.
Browse
Browses through a list of key field values in an overlay window. This helps you find and select a record. To temporarily add other fields to the browse list, press GET.
Join
Joins a related file and enables you to query the records related to the active record. For example, you can join an order file to a customer file to see the order records for a particular customer. See "Database Administration," for details on how to establish join relationships.
Query
Queries the current file using a query-by-example interface so you can select a subset of the records that appear in the current form.
In a query-by-example interface, you enter selection criteria into an empty form. When the blank form appears, you can enter an operator (for example, use > for greater than, >= for greater than or equal to) and then the value for the query.
For example, when you are looking at a customer record form, you can query on a customer number greater than 10. You can also enter criteria on multiple fields; multiple criteria, are automatically combined using AND. For example, a multiple criteria could be: customer number is less than 10 AND state equals Arizona.
Where
Builds a WHERE clause enabling you to select a subset of records using selection criteria that is slightly more complex than what you can specify with the Query option. For example, with the Where option you can select a subset of records from the customer file where the customer number is less than 10 or greater than 40 and the unpaid balance is less than $100.
The Where option in this module works the same way as it does in the Labels and Data Export modules, except that you do not have to pick an active file and there is no Ask mode. For a complete description of this option, see "Option Descriptions."
Total
Displays the total number of records available in the current working file or subset. For example, if you are looking at order records, you can use this option to tell you how many order records there are. It may take a few moments before the total appears at the bottom of the window if the file is large.
Order
Reorders the data in the current form using the ordering sequence dictated by another Progress index. When you choose this option, a list appears of all the fields (indexes) that you can use to reorder the data in the active query form. For example, if customer records are in order by customer number, you can change them to be in order by zip code.
Module
Switches to any other Results module (except Data Administration) without going back to the Main Menu. You can also transport file, field, and WHERE clause criteria information to other modules. For example, suppose you build a query to select all customers in the West sales region. Then you decide you want to print a report using that information. You use the Module option to take the WHERE criteria over to the Report module, then run a report based on the criteria. This saves time because you do not have to rebuild the WHERE clause.
Info
Displays the database name, file name, any selection criteria you used to define the current working set (or subset) of data, as well as order definition for the records. For example, you may have selected the Where option to define a subset of customer data, and put the records in order by zip code. This option displays that information.
User
Transfers to a customized option. This option is hidden by default; you see it only if an application developer has included an option program to perform an action. If you have this option, see supplemental documentation provided by the application developer that describes this function.
Exit
Exits the previous level. For example, you can exit from a subset of records to the full set. From the full set of records, you can then exit to the Results Main Menu.
  1. These options are enabled for the mysports database so that you can try them. When you run Results against your own Progress-supported database, these options might not appear on the menu. They are only included if your database administrator has enabled them.


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