Progress
Results User’s Guide
for UNIX


Changing the Order of Records

This section describes how to use the Order option to change the order of the records in the list. For example, in the mysports database, customer records are usually in order by customer number. To put the records in order according to another index field, follow these steps:

  1. Select the Order option.
  2. A window appears listing the possible indexes for the active file. For example, the following figure shows the indexes for the customer file.

    The fields in the window are the fields you can use to order the records. The fields listed in parentheses are the fields that make up each index. The Country-Post index is made up of two fields, Country and Postal-Code. Results orders the records by country and then by postal codes. For information on defining indexes, see Database Administration."

  3. Select the Country-Post index.
  4. The window still shows the same record.

  5. Select the Browse option.
  6. The window displays the records ordered by country then by postal codes. You can use ¦ and Ø to scroll up and down to look at other records.


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