Format VALID IF cond-expr
1 – Parameters
1.1 – cond-expr
Specifies an expression that forms the validation condition. See Expressions for more information on value expressions.
2 – Description
The VALID IF field property checks values assigned to a field to ensure that they are in the acceptable range for the field. The expression you specify must be a valid expression for the product evaluating it.
3 – Examples
1.CDO> DEFINE FIELD AMOUNT_OWED cont> DATATYPE IS UNSIGNED WORD cont> VALID IF AMOUNT_OWED > 0. In this example, the VALID IF field property in the DEFINE FIELD command specifies a range of valid values for the AMOUNT_ OWED field element. 2.CDO> CHANGE FIELD AMOUNT_OWED cont> NOVALID IF. In this example, the NOVALID IF keywords remove the VALID IF property from the AMOUNT_OWED field element.