MFC - CRecordset::GetFieldValue and nvarchar(MAX) returns no data

MFC - CRecordset::GetFieldValue and nvarchar(MAX) returns no data by Rene Laviolette

Closed

as Fixed

Type:	Bug
ID:	694793
Opened:	10/13/2011 1:17:39 PM
Access Restriction:	Public
Moderator Decision:	Sent to Engineering Team for consideration

Workaround(s)

view

User(s) can reproduce this bug

We started implementing nvarchar(MAX) into our database and now, whenever a call is made using CRecordset::GetFieldValue nothing is returned.

CDBVariant varValue;
rs.GetFieldValue((short)0, varValue);
sResult = CStringConvert::GetVariant_string(&varValue);

Reference this thread: http://social.msdn.microsoft.com/Forums/en-US/vcgeneral/thread/7598b084-9656-462c-a5d7-d9432789d14d

Details (expand)

Visual Studio 2010 SP1

Create a table containing a column with a nvarchar(max) data type. Open the RecordSet then make the following call and sResult will contain nothing:

CDBVariant varValue;
rs.GetFieldValue((short)0, varValue);
CString sResult = CStringConvert::GetVariant_string(&varValue);

It does work if you add the following code after the rsOpen is called:

rs.m_rgODBCFieldInfos[0].m_nSQLType = SQL_WLONGVARCHAR;

English

Windows 7

English

No data is returned

GetFieldValue should have returned the data in the database field.

0 attachments

Posted by Microsoft on 10/25/2011 at 4:47 PM

Hello Rene,

Thanks for the report. This issue has been fixed in MFC for the next major release of Visual Studio.

Pat Brenner
Visual C++ Libraries Development

Posted by MS-Moderator08 [Feedback Moderator] on 10/13/2011 at 8:00 PM

Thank you for submitting feedback on Visual Studio 2010 and .NET Framework. Your issue has been routed to the appropriate VS development team for investigation. We will contact you if we require any additional information.

Posted by MS-Moderator01 on 10/13/2011 at 1:44 PM

Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)