Specifications

Defining a code table
286 InfoMaker
How code tables are processed
When data is retrieved into a report or form column with a code table,
processing begins at the top of the data value column. If the data matches a data
value, the corresponding display value displays. If there is no match, the actual
value displays.
Consider the example in Table 8-10.
Table 8-10: Data values and display values
If the data is MA or ma, the corresponding display value (Massachusetts)
displays. If the data is Ma, there is no match, so Ma displays.
Case sensitivity
Code table processing is case sensitive.
If the code table is in a DropDownListBox edit style, and if the column has a
code table that contains duplicate display values, then each value displays only
once. Therefore, if this code table is defined for a column in a form that has a
DropDownListBox edit style, Massachusetts and Rhode Island display in the
ListBox portion of the DropDownListBox.
Validating user input
When you enter data into a column in a form, processing begins at the top of
the display value column of the associated code table.
If the data matches a display value, the corresponding data value is put in the
internal buffer. For each display value, the first data value is used. Using the
sample code table, if you enter Massachusetts, ma, or Mass, the data value is
MA.
You can specify that only the values in the code table are acceptable:
• For a column using the Edit edit style, select the Validate check box.
Display values Data values
Massachusetts MA
Massachusetts ma
ma MA
Mass MA
Rhode Island RI
RI RI