SqlUtilDefaultNullValue - cDbUpdateFunctionLibrary
To get the SQL default NULL value for a data type.
Type: Function
Parameters: String sDriverID Integer iDbType Integer iDataType
Parameter |
Description |
sDriverID |
The database driver ID. |
iDbType |
Enumeration value. Any of; EN_DbTypeDataFlex, EN_DbTypeMSSQL, EN_DbTypeMySQL, EN_DbTypeOracle, EN_DbTypeDB2 or EN_DbTypePostgre |
iDataType |
Any of the SQL data types. See SQL Server Type Mappings |
Syntax
Function SQLUtilDefaultNullValue String sDriverID Integer iDbType Integer iDataType Returns Boolean
Call: |
Get SQLUtilDefaultNullValue MSSQLDRV_ID to bOK |
Description
Returns the NULL value for an SQL data type as a string.
Example
Procedure OnClick
String sNullValue
Get SQLUtilDefaultNullValue of ghoDbUpdateFunctionLibrary MSSQLDRV_ID EN_DbTypeMSSQL SQL_DATETIME to sNullValue
Send Info_Box ("The NULL value is:" * sNullValue)
End_Procedure