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.

  • No labels