Filter
Top Products
CHAPTER 8 Displaying and Validating Data
DataWindow Designer User’s Guide 253
❖ To define a code table as a property of the DropDownDataWindow edit
style:
1 Specify the column that provides the display values in the Display Column
box.
2 Specify the column that provides the data values in the Data Column box.
3 If you want to restrict input to values in the code table, clear the Allow
Editing check box.
❖ To define a code table as a property of the EditMask edit style:
1 Select the Spin Control check box.
2 Select the Code Table check box.
3 Enter the display and data values for the code table.
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 8-9.
Table 8-9: 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.
Display values Data values
Massachusetts MA
Massachusetts ma
ma MA
Mass MA
Rhode Island RI
RI RI