Microsoft KB Archive/139994

= PRB: Specifying Table Name with Column Name in MFC DAO =

Article ID: 139994

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft Visual C++ 4.0 Standard Edition
 * Microsoft Visual C++ 4.1 Subscription

-



This article was previously published under Q139994





SYMPTOMS
If you add a table name qualifier to a column name in the DoFieldExchange of your CDaoRecordset-derived class where one is not required to resolve ambiguity, an exception will be thrown when the recordset is opened. The exception indicates that:

GetRows failed. The requested column is not a member of this recordset.



CAUSE
Specifying table name qualifiers for columns that are not ambiguous (where the column name is sufficient to uniquely identify the column) causes the assignment of retrieved data to bound columns that occurs in the GetRows function to fail.



RESOLUTION
Remove unnecessary table name qualifiers to avoid this behavior.



STATUS
This behavior is by design.

Keywords: kbdatabase kbprogramming kbprb KB139994

-

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

© Microsoft Corporation. All rights reserved.