Skip to content

DF_DATABASE_DEFAULT_DEFAULT_DATE

Sets up the default value that will be used when a Date column is created.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

String, temporary.

Access

Read/Write.

Values

Any valid default value for a date column.

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATE of {driverNumber} {databaseHandle} to {StringVariable}
Set_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATE of {driverNumber} {databaseHandle} to {StringVariable}

Driver Configuration Keyword

Default_Default_Date

Remarks

Sets up the default value that will be used when a date column is created. Columns can be created during conversion or within a restructure operation.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATE of iDriver hDatabase to sAttribValue
    Showln "Default Date: " sAttribValue
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.