REP001 - Create Fields

The Repository field definitions are the foundation of your business applications. Other objects in the Repository such as tables, components and functions are built from the basic field definitions. The centralization of a single definition and its reuse provide huge productivity benefits.

Objectives

• To highlight how the LANSA Repository increases developer productivity.

• To create the following fields in the repository (where iii=your initials):

Field Name Description Type / Length iiiDeptCode Department Code Alpha(4) iiiDeptDescription Department Description Alpha(20) iiiEmployNumber Employee ID Alpha(2) iiiSurname Employee Surname Alpha(25) iiiGivenName Employee Given Name Alpha(25) iiiSalary Employee Salary Decimal(11,2) iiiStartDate Employee Start Date DateTime(26) iiiEmployNotes Employee Notes String(512)

Note: These fields will be used to create the Department and Personnel tables in later repository exercises.

To achieve these objectives, you will complete the following:

Step 1. Prepare Your System

Step 2. Copy Fields

Step 3. Manually Create Fields

Step 4. Reference Fields

Step 5. Delete a field

Step 6. Create a Dynamic List for Your Fields

Step 7. Create and Execute Test Form

Step 8. Change your field definitions

Summary