Fetching records
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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.
| 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 |