The default setting for the DF_FILE_USE_DUMMY_ZERO_DATE attribute of a new table created in a structure operation.
Driver
The DataFlex SQL Drivers (SQL Server, DB2 and ODBC), revision 5 and higher
Boolean, temporary
Read/Write
True, False
Use cli.pkg
Get_Attribute DF_DRIVER_USE_DUMMY_ZERO_DATE of {driverNumber} to {BooleanVariable}
Set_Attribute DF_DRIVER_USE_DUMMY_ZERO_DATE of {driverNumber} to {True|False}
The default setting for the DF_FILE_USE_DUMMY_ZERO_DATE attribute of a new table created in a structure operation.
Function DriverIndex String sDriver Returns Integer
String sCurrentDriver
Integer iNumberOfDrivers iDriver iCount
Move 0 to iDriver
Get_Attribute DF_NUMBER_DRIVERS to iNumberOfDrivers
For iCount From 1 To iNumberOfDrivers
Get_Attribute DF_DRIVER_NAME of iCount To sCurrentDriver
If ( Uppercase(sCurrentDriver) = Uppercase(sDriver) ) Begin
Move iCount to iDriver
End
Loop
Function_Return iDriver
End_Function // DriverIndex
Procedure ShowDriverAttribute
Boolean bAttribValue
Integer iDriver
Get DriverIndex "MSSQLDRV" to iDriver
Get_Attribute DF_DRIVER_DEFAULT_USE_DUMMY_ZERO_DATE of iDriver to bAttribValue
Showln "Use dummy zero dates: " (If(bAttribValue, "YES", "NO"))
End_Procedure
The sample code above shows the current setting for a given driver.