Progress
Language Tutorial
for Character
Selecting Records
Record selection is the process of distinguishing which records are part of the set you want to work with and which are not. In a defined query, the results list represents the set of records you want to work with. With the results list established, you can ignore all the other records in the table. For example, you might want to select just those customers who have a balance due, or those items that are on order. This section describes the two main options for selecting records.
As a refresher, this is the basic syntax for the OPEN QUERY statement.
This syntax diagram shows a partial syntax for the record phrase, listing the selection options.
Table 9–1 introduces the record phrase selection options.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |