URGENT: Opening a Database table
Whe I open a recordset I get the following error.
Too few parameters. Expected 1
When I remove the m_strFilter statement ahead of Open(), then i don't get this error. my code is:
GradesSet.m_strFilter ="Grade Like "+ sGrade;
GradesSet.Open();
Can somebody help me!
Re: URGENT: Opening a Database table
m_strFilter="[field name] LIKE" + sValue
**************************
* Cao Jiling *
**************************
Re: URGENT: Opening a Database table
What's the field type of Grade?
If it's int or float use >,>=, BETWEEN , etc.
**************************
* Cao Jiling *
**************************
Re: URGENT: Opening a Database table
rather:
GradesSet.m_strFilter ="[Grades].[Grade] Like " +CString("'") + sGrade + CString("'");
thankx I got the idea!