Field Types: Character fields in LANSA are usually Alpha (up to 256 characters) or if longer, String fields. Numeric fields are most commonly defined as Decimal. It is recommended that dates and times are defined as DateTime fields.
In this step you will manually create three fields called iiiSalary, iiiStartDate and iiiEmployNotes.
1. The first field you will create is the iiiSalary decimal field.
a. Use the New button on the File menu and select Field.
The New field dialog will appear.
b. Enter the following characteristics for the field:
|
c. Select (ü) the option to Open in editor.
d. Select (ü) the Close option to close the New Field dialog. (When you are creating many fields in one go, it is convenient to keep the dialog open.)
e. Click the Create button to create the field and open the definition in the Editor.
2. Now that the field is open, you can edit all its characteristics.
a. In the Definition tab double-click Default value. In the Details tab enter a default value of 10000.
b. Click on Edit Mask. Set its value to 2.
c. The Edit Mask controls how the field is formatted when displayed. The drop-down for the Edit Mask shows samples of the edit masks. You can also press F1 to review the help text.
d. Leave all other field characteristics as their defaults.
e. Save the iiiSalary field definition.
f. Close the field definition.
3. Next, you will create a DateTime field which will be used to store the date an employee joined the department.
Select the New option on the File menu and select Field from the menu options.
The New field dialog will be displayed.
4. Enter the following characteristics for the field:
|
a. Deselect the option to Open in editor.
b. Uncheck the Close option so that the New field dialog will appear again.
c. Click the Create button.
The field has been created in the Repository but has not been opened in the Editor.
5. Next you will create a string field to store employee notes.
a. The New field dialog will appear again.
b. Enter the following characteristics for the field:
|
c. Press the Create button.
d. Add an Input Attribute of LC, to allow lower case.
e. Save and close the field definition.
You have now manually created fields iiiSalary, iiiStartDate and iiiEmployNotes.
