I cannot SELECT RECORD by CRecordset ?
C / C++ / MFC
1
Posts
1
Posters
0
Views
1
Watching
-
I want to get a record from MyTable which GroupID=3 AND account='abc' AND usename='tom'" but it alway ERROR "Too few parameters"
CMyRecordSet is; str.Format("GroupID=%d AND account=\'%s\' AND usename=\'%s\'" ,iGroupID ,theApp.m_strAccount ,theApp.m_strUsername); is.m_strFilter=str; is.Open();:mad::mad::mad::mad: Too few parameters. Expected 1. <= ERROR :eek: help me :doh: I think I do not do anything wrong in this SQL it similars withis.Open(AFX_DB_USE_DEFAULT_TYPE,"SELECT * FROM MyTable WHERE GroupID=3 AND account='abc' AND usename='tom'");both ERROR :((:((:((