Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/frmeng01_0360.htm]
You are here:

...

The application will search the employee table (xEmployee) using SELECT_SQL, using a search on Date of Birth comparing the month value only. In this step you will create a month field and define a static picklist visualization for it. This will be visualized as a combo box which returns a numeric month number.

1.  Create a new field, iiiMONTH based on the following:

Field Name

iiiMONTH

Description

Month

Type

Signed

Length

2

Decimals

0

RDMLX Enabled

No

Open in the Editor

Yes

 |
2.  With the new field open in the editor, select the Visualization tab.

     Use the toolbar button to insert a Static Picklist.
Image Removed

Image Added

3.  In the Field Parts panel, select the picklist item and create entries for each month.
Image Removed

Image Added
 

     The     The default appearance of a picklist is a DropDownList. Do not change this setting:
Image Removed

Image Added

4.  Set the properties of the VisualizationPicklist element in the Details tab:

a.  Change its MarginLeft to 0, to hide the label.

b.  Change its DefaultVisual property to True.

c.  Resize the DropDownList visualization as shown:
Image Removed

Image Added

5.  Save the field definition and close it.
[ Image Removed |../../index.htm#lansa/frmeng01_0360.htm]