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.


  • No labels