Progress
Results User’s Guide
for UNIX


Introduction

The Query module allows you to examine the contents of your Progress files, and any related data, through a series of menu options. It also provides two options that let you select subsets of records: the Query option and the Where option. The Query option enables you to enter as much information as you want into a blank record, then it finds all the records that fit the criteria you entered. Results automatically combines the selection criteria you enter with the AND operator. For example, you can use the Query option to:

The Where option enables you to build WHERE clauses to select record subsets. You can build WHERE clauses for any type of selection; that is, you can combine selection criteria using the AND or OR operator. For example, you can build WHERE clauses that:

Each query form can be generated automatically for all fields in a file, or generated from a user-selected subset of the fields within a file.

When you select the Query module from the Main Menu, Results displays a list of forms that you can work with. Press MODE to toggle between descriptions, filenames, and programs. You can select forms from any of these lists. Once you select a form, for example, Customer information, the first record in that file appears, as shown in Figure 4–1.

Figure 4–1: Layout of the Query Window

This window has several features. First, it displays record information, and the header at the top of the query form describes the set of records you can examine. In this case, it is the full set of customer records in the mysports database. Similarly, when you use the Browse option, you see the full set of customer records. When you start the Query module or select a new form using the View option, you always begin working with a full set of forms. When you use the Where or Query options to select a subset of records, you begin working with a subset of forms and the window header changes to Subset.

The window also shows horizontal menu options that let you work with other records in the active file. A message at the bottom of the window describes the function of the option that you have highlighted on the horizontal menu. The following sections describe the menu and other Query options in more detail.


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