m_pRecordset->Open("SELECT * FROM book where name like '"+cstr+"%'",_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
"SELECT * FROM book where name like '"+cstr+"%'" 最好用单独的变量来设置看看。 CString strSQL; strSQL = "SELECT * FROM book where name like '"+cstr; strSQL += "%'";
SELECT * FROM book where name like '"+cstr+"%'" 你编译能通过吗??应该不行吧 CString querystr = "SELECT * FROM book where name like '"+cstr+"%'"_pRecordset->Open(_variant_t(querystr),_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
_RecordsetPtr m_pRecordset=NULL; m_pRecordset->CreateInstace(__uuidof(Recordset));_bstr_t sql="SELECT * FROM book where name like '"+cstr+"%'"; m_pRecordset->Open(sql",_variant_t((IDispatch*m_pConnection,true), adOpenStatic,adLockOptimistic,adCmdText); .....
ACCESS的通用符号为*
SQL SERVER的为%
最好用单独的变量来设置看看。
CString strSQL;
strSQL = "SELECT * FROM book where name like '"+cstr;
strSQL += "%'";
你编译能通过吗??应该不行吧
CString querystr = "SELECT * FROM book where name like '"+cstr+"%'"_pRecordset->Open(_variant_t(querystr),_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->CreateInstace(__uuidof(Recordset));_bstr_t sql="SELECT * FROM book where name like '"+cstr+"%'";
m_pRecordset->Open(sql",_variant_t((IDispatch*m_pConnection,true),
adOpenStatic,adLockOptimistic,adCmdText);
.....