Progress
Programming
Handbook


Order of Fetched Records

The FOR EACH statement, OPEN QUERY statement, and PRESELECT option may use multiple indexes to satisfy a query. When multiple indexes are used, the order of returned records is not guaranteed. You can enforce an order by using the BY option.

The following example returns the selected customer records in ascending credit–limit order and within credit limit in name order:

FOR EACH customer BY Credit-limit BY Name: 


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