WBF085 – Update from a List

Objective

• To create an application to maintain employee details and notes.

• To process notes updates for selected list items.

• To demonstrate using the SELECT_SQL command.

The application includes:

• The main page, which handles the employee search and displays employee details and a list of employee notes.

• A Pop Up reusable part provides an Employee Notes Editor.

• A Message Box to display validation errors.

To achieve these objectives, you will complete the following:

Step 1. Create iiiSearchMonth Field

Step 2. Create Web Page

Step 3. Load Data into Search Dropdowns

Step 4. Add Search Logic to xEmployeeDataServer Server Module

Step 5. Add Search Logic to the Web Page

Step 6. Complete Web Page with Employee Details

Step 7. Retrieve Employee Details

Step 8. Update Employee Details

Step 9. Create a Pop-Up Note Editor

Step 10. Complete Note Editor Logic

Step 11. Implement Note Editor in Web Page

Step 12. Display Message Box for Employee Update

Summary

Before You Begin

Complete exercises WBF015A, WBF015B, WBF025, WBF055A, WBF055B and WBF065.