Objectives
- To apply the knowledge you have acquired in the previous exercises to create LANSA fields and a table with validation rules, virtual columns, PJCs and an index.
The table you will create will be called Employee Holidays iiiEmpHolidays (where iii=your initials) with columns based on the following fields:
iiiEmployNumber | Existing employee number field | |
|---|---|---|
iiiHolCode | Holiday Code | |
iiiHolStartDate | Holiday Start Date | Showtime = False |
iiiHolEndDate | Holiday End Date | Showtime = False |
iiiHolComments | Holiday Comments | Allow lower case |
iiiHolDuration | Holiday Duration (virtual field) | Edit Mask = 2 |
iiiSurnamePJF | Employee Surname (PJC from the employee table) |
- To create an application to maintain the table and another application to use the index to search the table.
To achieve these objectives, you will complete the following:
Step 1. Create the Table Definition
Step 2. Modify Field Definitions
Step 3. Add Rules to the Table
Step 4. Create and Execute a Test Form
Step 5. Add a Virtual Column to Your Table
Step 6. Create an Access Route and a Predetermined Join Column (PJC)
Step 7. Recreate the Employee Holidays Form
Step 8. Create an Index and Test
Summary
Some Helpful Tips
- If you need additional help to complete any of the steps, refer back to the exercises in the appropriate lessons.
- Remember to use F1 context help and the LANSA documentation.