Field_Value_Range - DataDictionary

Configures a range-type validation for a table column

Type: Property
Access: Write-Only
Data Type: String
Parameters: None

Parameters

Parameter	Type	Description
iField	Integer	Number of the column in the table
sMin	String	Lowest allowed value for column iField

Syntax

Set Field_Value_Range iField to sMin sMax

Access Type	Syntax
Write Access:	`Set Field_Value_Range to StringVariable/Value`

Description

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.

Sample

Set Field_Value_Range Field Customer.Discount to 0 60