REP011 Repository Summary

Show Contents List

REP011 - Repository Summary

Objectives

To use the knowledge you have acquired in the previous exercises to create LANSA fields and a file with validation rules, virtual fields, PJFs and a logical view.

The file you will create will be called Employee Holidays iiiEmpHolidays (where iii=your initials) with 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 (PJF from the employee file)

To create an application to maintain the file and another application to use the logical view to search the file.

To achieve these objectives, you will complete the following:

Step 1. Create the File Definition

Step 2. Modify Field Definitions

Step 3. Add Rules to the File

Step 4. Create and Execute a Test Form

Step 5. Add a Virtual Field to Your File

Step 6. Create an Access Route and a Predetermined Join Field (PJF)

Step 7. Recreate the Employee Holidays Form

Step 8. Create a Logical View and Test

Some Helpful Tips

If you need additional help completing any of the steps, refer back to the exercises in the appropriate lessons.

Remember to use the online Help and the LANSA documentation.

Show Contents List