Progress
Results User’s Guide
for UNIX


Browsing Through Records

This section describes how to use the Browse option to display summary lists of record information. It also shows you how to pick the fields that temporarily appear in the summary list. (See "Database Administration," for information on how to permanently change the default fields that appear in this list.)

  1. Select Browse.
  2. A partial list of the records in the customer file appears as shown in the following figure. The list begins with the current record:

    Browse displays a list of customer records with the default fields—Cust-Num, Country, Name, and Postal-Code.

    The position marker at the bottom of the window tells you the position of the current record relative to the list of records in the window. For example, when the window shows the whole list, the position marker is All Shown. When you are at the top or bottom of the list, the position marker is At Top and At Bottom respectively. When you are in the middle of a list that is too long to fit in the window, the marker is empty.

    Use the cursor keys to scroll through this list. You can use Browse to help you find a record among a small number of records. For example, if you do not know the customer number of Thundering Surf you can easily locate the record using the browse feature.

  3. Move through the list until you find Thundering Surf Inc. (customer number 16) and select it.
  4. All the fields in the Thundering Surf Inc. record appear.

  5. Select Browse again.
  6. The summary list of the customers in the customer file appears again.

    A message at the bottom of the window tells you to press GET if you want to set different browse fields. (If you want different default fields, see your database administrator.)

  7. Press GET. This list of fields appears:
  8. :

    The numbers next to the field names indicate fields that have been selected, in the order that they appear in the browse list.

    To add a field to the browse list, you highlight it and press RETURN. To delete a selected field, highlight it again and press RETURN.

    Notice that there are 16 fields you can choose. They do not all fit in the window. Use the cursor keys to scroll up and down the list to see these fields.

  9. Select the Sales-Rep field and press RETURN.
  10. A number 5 appears next to the field. This field will appear as the fifth field in the browse list.

    Note that if you select too many fields or a field too large to display across one line, the list reverts back to the default selected fields.

  11. Press GO to insert the Sales-Rep field into the browse list.
  12. The modified browse list appears:

    The Sales-Rep field is a temporary addition to the browse list. The browse list defaults back to its original fields when you exit the Query module. If you want to change the default fields for the list, see your database administrator.

  13. Press END to exit Browse.
  14. Select Total and the total number of records in the customer file appears at the bottom of the window:
  15. Press END to exit Total.

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