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_DUMMAY_ZERO_DATE_VALUE of {driverNumber} {databaseHandle} to {StringVariable}

Set_Attribute DF_DATABASE_DUMMAY_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.

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.