急!怪事!这两个语句有什么区别(ADO),高手请进!
bool fun(CString m_No,CString m_date)
{
//读出数据
_ConnectionPtr mMyDb;
_RecordsetPtr MySet;
_variant_t mHodler;
CString strTemp,strQuery;
//写入数据
mMyDb.CreateInstance(__uuidof(Connection));
mMyDb->Open("DSN=logindata;UID=user;PWD=user","","",-1);
MySet.CreateInstance(__uuidof(Recordset));
strQuery="Select * from beyond1 where f_ccbh='"+m_No+"' AND
f_ccrq='"+m_date+"'";
// _bstr_t(strQuery)
MySet->Open((_variant_t)strQuery,mMyDb.GetInterfacePtr(),adOpenDynamic,
adLockOptimistic,adCmdText);//* 此处运行出错!
....
return 0;
}
//*处总是出错,若把strQuery附值为:
strQuery="Select * from beyond1 where f_ccbh='"+m_No+"'";
或:
strQuery="Select * from beyond1 where f_ccrq='"+m_date+"'";
时,//*处能正确运行,
不知,Select * from beyond1 where f_ccbh='"+m_No+"' AND
f_ccrq='"+m_date+"'"如何写哦!