| Parameter | Description |
|---|---|
| iField | Number of the column in the table |
| sMin | Lowest allowed value for column iField |
| sMax | Highest allowed value for column iField |
| Write Access: | Set Field_Value_Range iField to sTrue sFalse |
Field_Value_Range allows you to define a minimum and maximum range for the column. It is expected that the column and its range will be Numeric or Date. The From value must be lower than the To value.
The validation is performed after the user has entered data into the column's data entry form. If the validation fails, then the user is prohibited from leaving the form. (The user may still exit the form by clicking elsewhere on the screen with the mouse).
When a validation error occurs, the error number and text specified for the column in the Field_Error property are used to report an error. If no text was defined, a standard check-error text will be reported.
The validation is also performed when a record is saved. If the validation fails, the save is aborted.
Set Field_Value_Range Field Customer.Discount to 0 60See Also
Defining Data Dictionary Field Attributes | Field_Value_Check | Field_CheckBox_Values | Field_Value_Table