Progress
Programming
Handbook


Using Field Lists

Using field lists with browse widgets can be an important way to speed up your application and minimize resource overhead. For example, if your application works with three fields from a database table with 15 fields, your application reads five times more data than it needs. Instead of reading the whole record in the query, you can use the field list syntax to list the subset of fields needed by your application. The subset of fields consists of those required by the browse and those required by the other parts of your application that get data from the buffers associated with the query.

The code fragment below shows an example of a field list in an OPEN QUERY statement:

OPEN QUERY my-query FOR EACH customer FIELDS (cust-num name credit-limit). 

For more information on field lists, see "Database Access" and the Record phrase entry in the Progress Language Reference .


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