FairCom Direct SQL for C and C++

ctsqlGetNumericAsString

Declaration

CTSQLRET ctsqlDECL ctsqlGetNumericAsString(pCTSQLCURSOR hCursor, INTEGER colnumber, CTSQLCHAR* buffer, INTEGER size)

Description

Retrieve the value of a numeric field.

Parameters

• hCursor - cursor handle
• colnumber - number of column
• buffer [out] - buffer to receive field data
• size - size of buffer

Return

Returns CTSQLRET_OK on success.

Prior to V12, a call to this function, or similar ctsqlGet*() functions for other data types, would fail with SQL_ERR_BADARG if the column value was a SQL NULL. These functions now return CTSQL_NULLRESULT if the data value is a SQL NULL. This change does not apply to ctsqlGetBinary or ctsqlGetBlob. Note: This modification is a Compatibility Change.

Note:

DSQL no longer allows using ctsqlGetChar() to retrieve long variable columns.