Progress
Results User’s Guide
for Windows
Modifying Records
You can use forms to update, copy, add, and delete records contained in a single table.
For example, if a query consists of the fields in the Customer table, you can use the Form view to modify the Customer table. However, if a query consists of fields from more than one table, you cannot modify the tables unless you use the Master-Detail feature to break the tables into individual frames. For more information, see the "Using Master and Detail Sections to Display Records" section in Analyzing Data."
The following sections explain how to modify records contained within a single table.
Updating Records
Follow these steps to change the contents of one or more fields in a record:
- Display the record you want to modify.
- Choose the Update button.
Results displays the fields in the Update window. The first field is highlighted by default:
![]()
- Select the contents of the field you want to modify, then type the new information in the field. The new information overwrites the old information.
- When you are done modifying fields, choose OK to save your modifications and close the Update window.
As you update fields, you might find that your modifications are restricted by a variety of factors. For example, you cannot update a calculated field because it is a display only field. Or perhaps your company assigns unique customer numbers so you cannot update the Cust-Num field.
Copying Records
Follow these steps to create a new record based on the contents of an old record. Be sure to follow the guidelines at your site for creating new records based on existing records:
- Display the record you want to copy.
- Choose the Copy button.
Results copies the record and displays the copy in the Update window. Results copies all the fields in the record whether or not the fields are displayed.
- Since you are creating a new record, you will probably have to update several fields to reflect the new information.
- When you are done modifying fields, choose OK to save your new record and close the update window.
Creating Records
Follow these steps to create a new record:
- Choose the Add button.
Results creates a new record that contains all the fields in the table, then displays the record in the Add window. Note that only the fields you chose to display in the query are displayed in the window:
![]()
Some of the fields might already contain values, as in the Credit-Limit field. These initial values are determined by the business practices established by your company and enforced by the database.
- Fill in the empty fields.
- When you are done filling in fields, choose OK to save your record and close the Add window.
Deleting Records
Follow these steps to delete a record:
- Display the record you want to delete.
- Choose the Delete button. A dialog box prompts you to verify that you want to delete the record.
- Choose Yes. Results deletes the entire record, including fields that are not displayed in the query.
You might find that you cannot delete a particular record. For example, you might not be able to delete a customer that has outstanding orders. Such restrictions are determined by your company’s business practices and are enforced by your database.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |