Release 10.1A: OpenEdge Development:
Programming Interfaces

> ## Fetching field lists

> When fetching records with a `FOR` `EACH` statement or query, Progress typically retrieves all the fields of a record, whether or not your application needs them. This can have a costly impact on performance, especially when browsing records over a network.

> Progress automatically optimizes preselected and presorted fetches from remote OpenEdge databases using field lists. A field list is a subset of the fields that define a record and includes those fields that the client actually requires from the database server. For preselected and presorted fetches, Progress can deduce this field list at compile time from the code.

> You can also specify field lists explicitly for many types of Progress record fetches, including:

> - Queries

> - `FOR` statements

> - `DO` `PRESELECT` statements

> - `REPEAT` `PRESELECT` statements

> - `SQL` `SELECT` statements

> This section explains how to use field lists in the Progress 4GL. For information on specifying field lists in `SQL` `SELECT` statements, see OpenEdge Data Management: SQL Development .

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