m_strFilter Problem
12-Jul-94 04:31:44
Sb: m_strFilter Problem
Fm: Steve Roeder [MSFT] 72262,1602
To: Ted Barbusinski 75460,1403
Hi Ted,
<<We have an odd problem with CRecordset::m_strFilter. We have an Access
database Table with a column labeled "Location" which is an indexed field
(CString type). When we issue a Open request with m_strFilter set to
"Location = OverThere" we get the following database exception message thrown
…
Error in expression.
'OverThere'
Invalid column name: 'OverThere'
>>
The syntax for the m_strFilter string should be:
m_strFilter = "Location = 'OverThere'";
Steve Roeder
Microsoft Developers Support