CDO$HELP.HLB  —  fld-properties  VALID_IF
    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.
Close Help