Objectives

  • To introduce the most common forms of database access including the following commands:
    • FETCH
    • INSERT
    • UPDATE
    • DELETE.
  • To learn about error handling using the IF_STATUS command when using table operations.
  • To learn how to use some of the program level validations commands:
  • BEGINCHECK / ENDCHECK
    • CALLCHECK
    • CONDCHECK
    • DATECHECK
    • FILECHECK
    • RANGECHECK
    • VALUECHECK
    • IF_ERROR, SET_ERROR.
  • To understand how program validations relate to the repository validation performed by the Object Access Modules (OAM).
  • To understand how to use a Built-In Function (BIF) to display a message box with user confirmation.
  • To create a simple application to maintain the table xDepartments.

To achieve these objectives, you need to complete the following:

Step 1. Create a Department Maintenance Form

Step 2. Fetch Existing Data from a Table

Step 3. Insert Data into a Table

Step 4. Add Program Level Validations

Step 5. Update Data in a Table

Step 6. Delete Data from the Table

Step 7. Update and Delete Last Record Read

Summary

Before You Begin

You should have completed the previous exercise.

  • No labels