Progress
Programming
Handbook


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 Progress 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:

This section explains how to use field lists in the Progress 4GL. For information on specifying field lists in SQL SELECT statements, see the Progress SQL-89 Guide and Reference.


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