Data type
When defining controls in which you specify a data type, usually with the TYPE property, consider the following:
- How will the data be analyzed after collection? Consider assigning sets of textual answers numeric values and coding them with a numeric TYPE if it will be convenient to handle them numerically in the statistical database. For example, you can assign Yes and No answers numeric values in the database by defining Yes and No data controls with a TYPE of INTEGER and values of 1 and 2.
- Will individual controls be included in compound controls such as lists or sets of radio buttons? All components of a compound control must have the same TYPE property.
- Will the submitted data be transmitted to a Customer-Defined Database? All components of multiple-selection controls (selections in a list box control or a set of check box controls) must be mapped to a target column with the STRING type.