The default setting for the DF_FILE_TABLE_CHARACTER_FORMAT attribute of a new table created in a structure operation.
Driver
The DataFlex SQL Drivers (SQL Server, DB2 and ODBC), revision 5 and higher
String, temporary
Read/Write
"OEM", "Ansi"
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"}
Default_Table_Character_Format
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.