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