FRM035 - Maintain a Simple Database Table
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 file 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.
- 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 DEPTAB file.
To achieve these objectives, you need to complete the following:
Step 1. Create a Department Maintenance Form
Step 2. Fetch Existing Data from a File
Step 4. Add Program Level Validations
Step 6. Delete Data from the File
Step 7. Update and Delete Last Record Read
Before You Begin:
In order to complete this exercise, you should have completed the previous exercise.
You may wish to review the following topics in the :
and