PRB: Varchar Output Parameter Causes "Data Truncated" Error

   Warning: ODBC Success With Info, Data truncated
   State:01004,Native:0,Origin:[Microsoft][ODBC SQL Server Driver]
					

CAUSE

This problem is caused by the way that parameters are bound in the RFX_Text function. The call to SQLBindParameter appears as follows:

   AFX_SQL_SYNC(::SQLBindParameter(pFX->m_hstmt, (UWORD)nField,
    (SWORD)pFX->m_nFieldType, SQL_C_CHAR, (SWORD)nColumnType,
    nMaxLength, nScale, pvParam, 0, plLength));
				

The problem is the next to the last parameter, the cbValueMax argument, which is hard coded to 0 (zero). The cbValueMax argument specifies the length of the buffer; it applies only to character data, not to numerics. If the number of bytes available to return is greater than or equal to this number, then the driver truncates it to cbValueMax-1 and null terminates it (and throws the error above). Because the parameter is hard coded to 0, the error will always be returned.

   AFX_SQL_SYNC(::SQLBindParameter(pFX->m_hstmt, (UWORD)nField,
   (SWORD)pFX->m_nFieldType, SQL_C_CHAR, (SWORD)nColumnType,
   nMaxLength, nScale, pvParam, nMaxLength, plLength));