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