Product Documentation

FairCom DB V12 Updates

Previous Topic

Next Topic

ctsqlGet*() Returns CTSQL_NULLRESULT when a NULL Value Is Present

Prior to this revision, a call to ctsqlGetChar(), or other similar 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 affects the following functions:

  • ctsqlGetBigInt
  • ctsqlGetBit
  • ctsqlGetChar
  • ctsqlGetDate
  • ctsqlGetFloat
  • ctsqlGetInteger
  • ctsqlGetMoney
  • ctsqlGetNChar
  • ctsqlGetNumeric
  • ctsqlGetNumericAsString
  • ctsqlGetReal
  • ctsqlGetSmallInt
  • ctsqlGetTime
  • ctsqlGetTimeStamp
  • ctsqlGetTinyInt

It does not apply to ctsqlGetBinary or ctsqlGetBlob.

Note: This modification is a Compatibility Change.

TOCIndex