Progress
Results User’s Guide
for UNIX


Menu Options for the Query Module

Next

Finds the next record in the file or subset according to the current active index and selection criteria.

Prev

Finds the previous record in a file or subset.

First

Finds the first record in a file or subset. For example, if the records are in order by customer number, the First option finds the record with the lowest customer number. If you are in a subset of a file, First finds the first record in the subset. (You can change the order records are listed in by using the Order option.)

Last

Finds the last record in a file or subset.

Add

Adds a new record to the file using the current form (if you have permission). If you select this option when you have two or more files joined, you see default information that you can keep or change in the add window. The information entered is automatically verified, and an error message appears if there is a problem.

Update

Updates the currently displayed record (if you have permission). The information entered is automatically verified, and an error message appears if there is a problem.

Copy

Copies the currently displayed record to a new record (if you have permission). Enables you to copy the record displayed on the screen to create a new record, and then update the new record’s contents. The information entered is automatically verified, and an error message appears if there is a problem.

Delete

Deletes the currently displayed record (if you have permission). A prompt appears that you can respond to if you want to delete the record.

View

Selects a different query form to view.

Browse

Browses through a scrolling list of key field values in an overlay window.

You can temporarily add other fields to appear in the Browse list by pressing GET (F5 or CTRL-G). When the list of fields appears, select (or deselect) fields to tailor the list. The Browse list defaults back to its original settings when you select too many fields or a field too large to display across one line. The Browse list also defaults back to the original settings when you exit the Query module. To permanently change the default fields, see your database administrator or see "Database Administration," for information on controlling fields in the Browse window.

The Browse list appears in a window that has a position marker at the bottom to tell you how much of the list is shown. The markers are: All Shown, At Top (when the top is shown), and At Bottom (when the bottom is shown). The marker remains empty if the top and bottom of the list are not shown.

When you choose this option after selecting a subset of information using the Join, Where, or Query options, Browse only displays summary information about the records in the subset you are working with.

Join

Joins to a related file and enables you to query the records related to the current active record.

When you select this option, a window pops up with a list of the files that you can join to the current file. See "Database Administration," for details on how to establish join relationships.

Query

Queries the current file using a Query-By-Example interface.

Choosing this option places you in a blank copy of the current screen form, where you may enter an operator (for example, use > for greater than, >= for greater than or equal to, and so on) and then the value for the query. (Select this option then press the HELP key (F2 or CTRL-W) to see a complete list of comparisons.)

Once you press GO (F1 or CTRL-X), the software applies the selection criteria to the current active file, and places you in the main Query screen, using the subset of data you selected. The list of fields you can enter Query criteria on are controllable through the Administration module. If you choose the Query option while already using a subset, the existing Query criteria appear, and you can edit them. If you want to reset all the Query criteria and start again, press INSERT LINE to remove all the existing criteria, then enter the criteria you want.

Where

Builds a WHERE clause enabling you to select a subset of records using selection criteria that is more complex than you can specify with the Query option.

The Where option in the Query module works the same way as it does in the other modules, with a few important exceptions. For example:

Total

Displays the total number of records available in the current working file or subset.

Order

Reorders the data currently being displayed using the ordering sequence dictated by another Progress index. When you choose this option, a list appears of all the fields (indexes) you can use to reorder the data in the active query form.


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