How code tables are processed
When data is retrieved into a DataWindow object 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 22-10.
|
Display |
Data |
|---|---|
|
Massachusetts |
MA |
|
Massachusetts |
ma |
|
ma |
MA |
|
Mass |
MA |
|
Rhode Island |
RI |
|
RI |
RI |
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 DataWindow object that has a DropDownListBox
edit style, Massachusetts and Rhode Island display in the ListBox
portion of the DropDownListBox.