FIX: GetFieldValue Returns Empty String for SQL_LONGVARCHAR

MORE INFORMATION

1. If you do not currently have a class derived from CRecordset, create one. If you have multiple classes derived from CRecordset, you may want to create a new base class derived from CRecordset and modify your existing recordset classes to be derived from this new base class so that you do not have to make the changes to every recordset class.
   
   For example, create GetSet.H:

         class CGetSet : public CRecordset
         {
         public:
             CGetSet(CDatabase* pDatabase = NULL);
         };
   
         and GetSet.CPP:
   
         #include "stdafx.h"
         #include "GetSet.h"
   
         CGetSet::CGetSet(CDatabase* pdb)
             : CRecordset(pdb)
         {
         }
   						

2. Copy the prototypes of the CRecordset GetFieldValue() and GetLongCharDataAndCleanup() functions from MSDEV\MFC\SRC\AFXDB.H to your recordset .H file as public member functions. Note that all four of the GetFieldValue() prototypes must be copied.
3. Copy the implementations of the CRecordset::GetFieldValue() and CRecordset::GetLongCharDataAndCleanup() functions from MSDEV\MFC\SRC\DBCORE.CPP to your recordset .CPP file. Change the "CRecordset::" prefix to your new class name. Note that all four of the GetFieldValue() implementations must be copied.
4. In your implementation of GetLongCharDataAndCleanup(), replace "<" with "<=".
   
   Change:

         // If long data, may need to call SQLGetData again
         if (nLen < nActualSize &&
             (nSQLType == SQL_LONGVARCHAR || nSQLType == SQL_LONGVARBINARY))
   						

   to:

         // If long data, may need to call SQLGetData again
         if (nLen <= nActualSize &&
             (nSQLType == SQL_LONGVARCHAR || nSQLType == SQL_LONGVARBINARY))
   							

5. If you were using the CRecordset class directly, you will need to change your application to use the new class instead.