DF_DRIVER_DEFAULT_TABLE_CHARACTER_FORMAT

The default setting for the DF_FILE_TABLE_CHARACTER_FORMAT attribute of a new table created in a structure operation.

Level

Driver

Supported by

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

Type

String, temporary

Access

Read/Write

Values

"OEM", "Ansi"

Syntax

Use cli.pkg

 

Get_Attribute DF_DRIVER_DEFAULT_TABLE_CHARACTER_FORMAT of {driverNumber} to {StringVariable}

Set_Attribute DF_DRIVER_DEFAULT_TABLE_CHARACTER_FORMAT of {driverNumber} to {"OEM"|"Ansi"}

Driver Configuration Keyword

Default_Table_Character_Format

Remarks

The default setting for the DF_FILE_TABLE_CHARACTER_FORMAT 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

    String sAttribValue

    Integer iDriver

 

    Get DriverIndex "MSSQLDRV" to iDriver

    Get_Attribute DF_DRIVER_DEFAULT_TABLE_CHARACTER_FORMAT of iDriver to sAttribValue     

    Showln "Default table character format: "sAttribValue

End_Procedure

The sample code above shows the current setting for a given driver.