Progress
Language Tutorial
for Character
Uses of the Record Phrase
This chapter focuses on the record phrase. The record phrase is the language structure that supports most of your options for selecting, sorting and relating records. Before focusing on the record phrase itself, take a moment to review the different contexts which employ the record phrase:
- The FIND statement locates an individual record. The record phrase options help specify the record.
- The FOR EACH block is most valuable in batch applications where records are processed linearly. The options of the record phrase help select which records are executed with the statements inside the block. You can also sort and relate records with the FOR EACH block.
- The OPEN QUERY statement establishes a results list of records. Record phrase options help select, sort, and relate the records to form the results list.
To continue the focus on interactive database applications, this chapter teaches record phrase options in the context of a defined query. Notes along the way point out any significant differences in the use of an option with FIND or FOR EACH.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |