Skip to content

DF_DATABASE_COLUMN_CREATE_DEFAULTCLAUSE

Can be used to set up column default support.

Level

Database

Supported by

DataFlex ODBC Driver, revision 5 and higher

Type

Boolean, temporary

Access

Read/Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_COLUMN_CREATE_DEFAULTCLAUSE of {driverNumber} {databaseHandle} to {BooleanVariable}
Set_Attribute DF_DATABASE_COLUMN_CREATE_DEFAULTCLAUSE of {driverNumber} {databaseHandle} to {True|False}

Driver Configuration Keyword

Column_Create_Defaultclause

Remarks

Some ODBC drivers do not accurately report capabilities. A number of settings have been created to correct that problem. If a driver reports that it supports a feature that it really does not support (or vice versa), errors can occur.

The DF_DATABASE_COLUMN_CREATE_DEFAULTCLAUSE can be used to set up column default support. A column default value is used when creating a new record and no value is supplied for the column. The actual default value can be set in the DF_FIELD_DEFAULT_VALUE attribute.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    Integer iAttribValue
    Get_Attribute DF_DATABASE_COLUMN_CREATE_DEFAULTCLAUSE of iDriver hDatabase to iAttribValue
    Showln "Column create default: " (If(iAttribValue, "YES", "NO"))
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.