FIX: Text Truncated When Using Dynaset and RFX_Text()

RESOLUTION

1. In one of your header files, perhaps in your CRecordset's header file, create the following function prototype:

       void RFX_Text2(CFieldExchange* pFX, const char *szName,
          CString& value, int nMaxLength=255, int nColumnType=SQL_VARCHAR);
   						

2. In your CRecordset's .CPP file or elsewhere, add the RFX_Text2() definition shown below:

      ****
      void RFX_Text2(CFieldExchange* pFX, const char *szName,
                     CString& value, int nMaxLength, int nColumnType)
      {
        ASSERT(AfxIsValidAddress(pFX, sizeof(CFieldExchange)));
        ASSERT(AfxIsValidString(szName));
        ASSERT(AfxIsValidAddress(&value, sizeof(CString)));
   
        if (pFX->m_nOperation==CFieldExchange::BindFieldForUpdate)
        {
          UINT nField;
          if (!pFX->IsFieldType(&nField))
            return;
   
       LONG* plLength = pFX->m_prs->GetFieldLength(pFX);
   
       if (!pFX->m_prs->IsFieldFlagDirty(nField, pFX->m_nFieldType))
       {
         // If field is not dirty, set bound length to SQL_IGNORE
         // for SQLSetPos updates
         *plLength = SQL_IGNORE;
       }
       else if (!pFX->m_prs->IsFieldFlagNull(nField, pFX->m_nFieldType))
       {
         // plLength always set to SQL_NULL_DATA in AddNew mode
         *plLength = value.GetLength();
       }
       return;
        }
   
        RFX_Text(pFX, szName,value, nMaxLength,nColumnType);
   
      }
   
      ****
   						

3. Modify the DoFieldExchange member function of your CRecordset class, replacing calls to RFX_Text with calls to the RFX_Text2 function described above.