[ |../../index.htm#lansa/frmeng01_0025.htm]
You are here:

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 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.
[ |../../index.htm#lansa/frmeng01_0025.htm]