Specifications

CHAPTER 8 Displaying and Validating Data
Users Guide 287
• For the DropDownListBox and DropDownDataWindow edit styles, clear
the Allow Editing check box: you 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.
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.
About validation rules
When you enter data in a form, you want to be sure the data is valid before
using it to update the database. Validation rules provide one way to do this.
You usually define validation rules in the Database painter. To use a validation
rule, you associate it with a column in the Database painter or Report painter.
InfoMaker uses validation rules when you enter data:
• Directly in the database using the Database painter
•In a form
Another technique
You can also perform data validation through code tables, which are
implemented through a column’s edit style.
For more information, see “About edit styles” on page 270.