Fetching records

After you define a set of records, ABL must fetch the records. How ABL fetches records depends in part on which statements you use to fetch the records. The following table summarizes the differences in record fetching between the FIND, FOR EACH, OPEN QUERY, and PRESELECT statements.

Table 4. 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

In this section:

Order of fetched records

Sample record fetches

ROWID and RECID data types

Results lists

FIND repositioning