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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |