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 requested validation 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 Allow Editing is false,
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.