Validation

Description

The validation expression for the specified column. Validation expressions are expressions that evaluate to true or false. They provide checking of data that the user enters in the DataWindow.

To set the validation expression, you can also use the SetValidate method. To check the current validation expression, use the GetValidate method.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.Validation { = ' validationstring ’ }"

Parameter

Description

columnname

The column for which you want to get or set the validation rule..

validationstring

(exp) A string containing the rule that will be used to validate data entered in the column. Validation rules are expressions that evaluate to true or false. Validationstring is quoted and can be a DataWindow expression.

Usage


In the painter

Set the value using the Column Specifications view, Validation Expression option.

Use operators, functions, and columns to build an expression. Use Verify to test it.

Examples

Example 1

[Visual Basic]
setting = dw1.Describe("emp_status.Validation")