WBF035 – Maintain a Simple Database Table

Objective

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 database table operations.

• To understand how to use a Built-In Function (BIF) to display a message box with user confirmation.

To achieve these objectives, you will complete the following:

Step 1. Create a Departments Server Module

Step 2. Create a Department Maintenance Web Page

Step 3. Fetch Existing Data from a Table

Step 4. Insert Data to a Table

Step 5. Add Field Error Handling

Step 6. Update Data in a Table

Step 7. Delete Data from a Table

Step 8. Display Error Messages

Summary

Before You Begin

Complete exercises WBF015A, WBF015B and WBF025