Filter
Top Products
Defining a code table
254 DataWindow .NET
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.
Validating user input
When users enter data into a column in a DataWindow object, 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 the user enters 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.
If you have selected the Validate check box for the Edit edit style, an
ItemError event is triggered whenever a user enters a value not in the code
table. Otherwise, the entered value is validated using the column's
validation rule, if any, and put in the DataWindow buffer.
• For the DropDownListBox and DropDownDataWindow edit styles, clear
the Allow Editing check box: users cannot type a value.
Although users cannot type a value when you clear the Allow Editing
check box, they can search for a row in the drop-down list or DataWindow
by typing in the initial character for the row display value. The search is
case sensitive. For the DropDownDataWindow edit style, the initial
character for a search cannot be an asterisk or a question mark. This
restriction does not apply to the DropDownListBox edit style.
When the code table processing is complete, the ItemChanged or ItemError
event is triggered.
Code table data
The data values in the code table must pass validation for the column and must
have the same datatype as the column.