Progress
Results User’s Guide
for UNIX


Adding and Deleting a Record

This section describes how to add a record to a file and delete a record from it.

Adding a Record
  1. Select Add.
  2. A blank record appears so you can add values to create a record. The fields you can edit are highlighted or underlined, depending on your monitor type. Notice that the Cust-Num field contains the number 1005 as shown in the following screen. This number is created automatically by Progress via the Sequence feature in the Data Dictionary. The default initial value of the sequence has been set to 1000 and the incremental value to 5. That’s why when you select Add, the number 1005 appears. If you select Add again to add another record, the next number you see is 1010, and the next one is 1015, and so forth. You can access the Dictionary to reset the initial and incremental values to different values.

  3. Accept the value 1005, and press RETURN to go to the next field.
  4. Fill in the rest of the fields with the data in Table 3–3.
  5. Table 3–3: Field Information for New Record  
    Field
    Information
    Name
    Windbag Windsocks
    Address
    2 Flyhigh Road
    City
    Chicago
    State1
    IL
    Postal-Code
    60628
    Contact
    Ronald Scott
    Phone
    (312) 456-3769
    Sales-Rep1
    DKP
    1. Results automatically verifies information you enter into these fields. If you try to enter an invalid value, you get an error message.

    Press TAB or any cursor key to move among fields. To edit a field, simply type over existing information.

  6. Press GO to add this record to the mysports database.
  7. NOTE: If there is already a customer number 1005 in the database, this error message appears:

          ** customer already exists with Cust num 1005. (132) 
    

    Results automatically verifies the information you enter. If it is invalid, Progress returns an error message. (To find an available customer number, you can use the Browse option described in the "Browsing Through Records" section.)

Deleting a Record

Follow these steps to delete the current record, that is, customer 1005.

  1. Verify that customer 1005 is the current record.
  2. Select Delete.
  3. A window appears that prompts you to verify whether you want to delete the current record.

  4. Select YES. Results deletes the record from the mysports database and removes it from the screen. Results displays the last record in the customer file.
  5. Select First.

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