Microsoft KB Archive/166939

= BUG: CRecordset::Update Fails After Upgrading =

Article ID: 166939

Article Last Modified on 12/8/2003

-

APPLIES TO


 * Microsoft Visual C++ 4.2 Enterprise Edition
 * Microsoft Visual C++ 4.2 Enterprise Edition
 * Microsoft Visual C++ 5.0 Enterprise Edition
 * Microsoft Visual C++ 4.2 Professional Edition
 * Microsoft Visual C++ 4.2 Professional Edition
 * Microsoft Visual C++ 5.0 Professional Edition

-



This article was previously published under Q166939



SYMPTOMS
After you recompile it with Visual C++ 4.2 or Visual C++ 5.0, an MFC/ODBC application built with Visual C++ 4.0 or 4.1 begins to fail in CRecordset::Update.



CAUSE
MFC 4.2 removes the "FOR UPDATE OF" clause from SELECT statements generated for all CRecordset objects.

Some ODBC drivers depend on this syntax and will fail to process the SQL when it is not found.



RESOLUTION
A member variable CDatabase::m_bAddForUpdate was added in MFC 4.2 to internally control the inclusion of the "FOR UPDATE" clause.

Setting this variable to TRUE before opening the recordset will cause "FOR UPDATE" to be appended to the generated SQL statement.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
CDatabase::m_bAddForUpdate is an undocumented member of CDatabase and as such is not guaranteed to have the same use or even exist in future versions of MFC.

It is offered for use in this article as a workaround only for this current problem.

This problem is not believed to affect many ODBC drivers.

Additional query words: kbvc420bug kbvc500bug kbmfc kbdatabase kbodbc

Keywords: kbbug KB166939

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.