Skip to content

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.

Example

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.