Product Documentation

FairCom Direct SQL for C and C++

Previous Topic

Next Topic

ctsqlGetReal

Retrieve a 32 bit float field.

Declaration

CTSQLRET ctsqlGetReal(pCTSQLCURSOR hCursor, INTEGER colnumber, SMALLFLOAT* buffer)

Description

ctsqlGetReal() retrieves the value of a 32 bit float field, given its cursor and column.

  • hCursor the cursor handle.
  • colnumber the column number.
  • buffer the buffer that will store the field data.

Return

ctsqlGetSmallFloat() 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.

Symbolic Constant

Explanation

SQL_ERR_BADARG

Bad arguments

Note:

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

See Also

ctsqlGetBytes(), ctsqlGetNChar(), ctsqlGetNumeric(), ctsqlGetSmallInt(), ctsqlGetInteger(), ctsqlGetFloat(), ctsqlGetDate(), ctsqlGetMoney(), ctsqlGetTime(), ctsqlGetTimeStamp(), ctsqlGetTinyInt(), ctsqlGetBinary(), ctsqlGetBit(), ctsqlGetBigInt(), ctsqlGetBlob()

TOCIndex