Progress
Results User’s Guide
for UNIX
The Query Module
This section of the tour introduces you to some Query features which let you examine database record information. You can stop and exit Results at anytime in this module. For more information about the Query module, see Query Module."
Follow these steps to select query forms.
- Type q to select the Query module from the Main Menu, as shown in this figure:
![]()
A list appears as shown in Figure 3–1. This list displays the Query forms you have permission to view.
Figure 3–1: Query Form
![]()
Results can list the query forms in one of three ways:
- By Description. The marker in the lower-left corner of the window tells you that this is a list of form descriptions. The counter in the lower right corner shows you how many forms there are in the list. For example:
![]()
- By File Name. The same list shows the names of the files used to make the forms. The database name appears in parentheses, so you know which database contains the file. All of the files in the following example are in the mysports database because that is the database you used to start Results for the tour. When you start with another database or more than one database, you see other database names in parentheses.
![]()
- By Program Name. Results automatically creates these program names using the first eight characters of the database filename. If any of these names is already used by other programs, it creates names like qryxxxxx.p for the programs, where xxxxx represents a unique integer value. Thus, each query form has its own unique program name so new query forms do not overwrite existing query forms that have the same name.
![]()
- Press MODE to toggle to each type of list.
- Toggle back to the description form list. (In this tutorial, you work only with the description list.)
There are two ways to select a form from the list:
- Highlight the form with the ¦ and Ø keys or TAB key and press RETURN or GO to select the form.
- Type the first letter of the form. The highlight moves to the form. Press RETURN to select the form.
If there is more than one form that begins with the same letter, the highlight bar moves to the first occurrence of the letter. If you type a letter for a form not on the list, the screen displays the letter in the box, but the highlight bar does not move. You can then type a letter for a form that exists, and this letter replaces the one in the box.
- Type c to highlight the Customer information form. This screen appears:
![]()
- Press RETURN to select the Customer information form.
The first record in the
customer
file appears, as shown in this screen:
![]()
This form shows you information about customer number 1 in the customer file of the mysports database. Each customer record appears in this format. The next section describes how to view other records.
There is a menu of options at the top of each form. There are two ways to select an option:
- Highlight the option with the ¨ and
keys, SPACEBAR, or TAB key and press RETURN or GO to select the form.
NOTE: Your database administrator can set Results to default to the European numeric format by setting the European Numeric Format (-E) startup option. If that startup option is set, the numbers on your screen appear in European numeric format. For more information about the -E startup option, see "Field Display Formats."- Type the first letter of the option. Results highlights the option and selects it.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |