Progress
Language Tutorial
for Windows


Sorting Records with the USE-INDEX Option

The USE-INDEX option of the record phrase allows you to choose the defined index by which you want to access the selected records. Usually, it’s more efficient to use BY and let Progress pick the indexes for you. Since FIND does not support BY, USE-INDEX comes in handy with this statement. Review the following code example that presents the USE-INDEX option:

OPEN QUERY My-Query FOR EACH Item WHERE Price > 50 USE-INDEX Item-Name 

In this example, the records for all items over $50 are sorted by product name.


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