The default setting for the "nullability" of newly created ASCII columns.
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_DEFAULT_NULLABLE_ASCII of {driverNumber} to {BooleanVariable}
Set_Attribute DF_DRIVER_DEFAULT_NULLABLE_ASCII of {driverNumber} to {True|False}
Default_Default_Nullable_Ascii
Columns can be allowed to contain null values, so called "nullable" columns. This attribute sets up the default "nullability" of ASCII columns. In general we recommend to not allow null values in columns (of any type). See the section Null values and defaults for more information.
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_NULLABLE_ASCII of iDriver to bAttribValue
Showln "Default nullable ASCII: " (If(bAttribValue, "YES", "NO"))
End_Procedure
The sample code above shows the current setting for a given database.