Progress
Programming
Handbook


Fetching Records

After you define a set of records, Progress must fetch the records. How Progress fetches records depends in part on which statements you use to fetch the records. Table 9–3 summarizes the differences in record fetching between the FIND, FOR EACH, OPEN QUERY, and PRESELECT statements.

Table 9–3: Record Fetching 
Statement
to Define Set of
Records
Statement
to Fetch
the Records

Structure Used
to Locate Records
FIND
FIND
Index
FOR EACH
FOR EACH
Results List or Index
OPEN QUERY
GET
Results List or Index
DO PRESELECT or
REPEAT PRESELECT
FIND
Results List


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