CRecordset/DoFieldExchange not working properly in Visual Studio 2010 by Synergy2010

I applied VS2010 SP1 Beta, release build works fine but debug build still don't handle NULL values correctly with IsFieldNull(). Anyone experiencing the same issue with SP1 or is it just my debug builds?

I ran into this issue after hundreds of man hours of converting our code to VS2010. After trying the original fix that was proposed and realizing it didn't work, as I was about to run screaming into the street, I saw the link that it was going to be fixed in SP1, great! Then I realized from that thread that it has been OVER A YEAR since this problem was found and there didn't appear to be a fix yet!!! So once again before running into the street, I checked MSDN and to my great surprise SP1 Beta had just been uploaded today!!!!!!

I can confirm that so far that VS2010 SP1 Beta fixes this issue for us with no code changes required.

And when this service pack will be available? we have purchased over 10 000$ of visual studios 2010 and we can't use them because of that regression.

Hello,

Thanks again for the report. This issue has been fixed for Visual Studio 2010 SP1.

Pat Brenner
Visual C++ Libraries Development

I am a co worker of Synergy2010
We like everyone have a target for release of current efforts
That would be end of Septemper
A hot patch to get us out the door would be much appreciated, unless a service pack is expected by that time.

Hello,

Thanks for the report. We have fixed this issue in MFC by reverting to VS2008 behavior in the CRecordSet class and plan to include this fix in a service pack for VS2010.

Pat Brenner
Visual C++ Libraries Development

We have got your files.

Thank you

I have attached the file SimpleDB.zip which is just a wizard generated MFC database app that uses a CRecordset derived class. The app assumes the existence of an SQL Server table called TestTable which looks like:

CREATE TABLE [dbo].[TestTable](
    [ID] [char](10) NOT NULL,
    [TxtCol1] [varchar](50) NOT NULL,
    [NumCol1] [numeric](10, 0) NULL,
CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED )

The ChildView class has an event handler for the menu item File/Run that instantiates the CRecordset derived class, opens it, moves through the rows in the recordset and closes it. If any row in the table has a NULL value for NumCol1 you will see the problem. RFX_Double() in DoFieldExchange() will return and the member variable that is bound to that column will have a huge, invalid value. I have tested this with RFX_Long as well with the same result on integral columns.

Please note that our software has been running for 8 years using CRecordset build with VS 2003, 2005 and 2008 with NO problems. As soon as we build with VS 2010 we get the above behavior - even in just a wizard created database app.

Thanks for reporting the issue.
In order to fix the issue, we must first reproduce the issue in our labs. We are unable to reproduce the issue with the steps you provided.

Could you please attach a zipped project file to this feedback through our site to help us reproduce the issue?

Thanks again for your efforts and we look forward to hearing from you.
Visual Studio Product Team

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)