Skip to content

DF_DATABASE_DUMMY_ZERO_DATE_VALUE

Sets up the value of the dummy zero date.

Level

Database

Supported by

DataFlex ODBC Driver, revision 5 and higher

Type

String, temporary

Access

Read/Write

Values

Any legal date value on the back end.

Syntax

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

Driver Configuration Keyword

Dummy_Zero_Date_Value

Remarks

Sets up the value of the dummy zero date. This should be set to the lowest possible date value that the database supports. In most databases, the default 0001-01-01 can be used. Some databases, however, support a different lowest possible date value.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DUMMY_ZERO_DATE_VALUE of iDriver hDatabase to sAttribValue
    Showln "Dummy zero 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.