UtilColumnTypeToString - cDbUpdateFunctionLibrary

To convert between a data type integer constant value and its string value (data type name in SQL). Returns a string value.

Type: Function

Parameters: String sDriverID, Integer iDbType, Integer iDataType

Parameter	Description
sDriverID	DataFlex, MSSQLDRV_ID, DB2_DRV_ID, ODBC_DRV_ID, ORAFLEX, SQLFLEX, MDSPgSQL or MDSMySQL.
iDbType	Database type; Microsoft SQL Server, IBM DB2, Oracle, MySQL or PostgreSQL. This is a enumeration type and can be any of; EN_DbTypeDataFlex, EN_DbTypeMSSQL, EN_DbTypeMySQL, EN_DbTypeOracle, EN_DbTypeDB2 or EN_DbTypePostgre.
iDataType	E.g. "VarChar" -> SQL_VarChar (If driver is MSSQLDRV_ID and the iDbType is EN_DbTypeMSSQL)

Syntax

Function UtilColumnTypeToString String sDriverID Integer iDbType Integer iDataType Returns String

Call:

Get UtilColumnTypeToString DataFlex_ID EN_DbTypeDataFlex SQL_VarChar to sDataType

Description

To convert between a string data type and its data type constant. The reciprocal of the UtilColumnTypeToInteger function. See also: tColumnType struct definition.

Example

Procedure OnClick

String sDataType

Get UtilColumnTypeToString MSSQLDRV_ID EN_DbTypeMSSQL SQL_VarChar to sDataType

End_Procedure