Format

      [NO]DEFAULT_VALUE FOR SQL  IS  value-expr

1  –  Parameters

1.1  –  value-expr

    Specifies an expression a product can use to calculate a field's
    value. See Expressions for more information on value expressions.

2  –  Description

    The DEFINE FIELD, CHANGE FIELD, and EDIT FIELD commands accept
    the DEFAULT_VALUE FOR SQL syntax.

    The CHANGE FIELD command accepts the NODEFAULT_VALUE FOR SQL
    keyword that deletes the default value for SQL.

    The SHOW FIELD and EXTRACT FIELD commands process the attributes.

3  –  Examples

    1.CDO>  DEFINE FIELD AMOUNT
      cont> DATATYPE TEXT 5
      cont> DEFAULT_VALUE FOR SQL IS "-----".

      This example shows the definition of the AMOUNT field with a
      default value for SQL of dashes.