_RecordsetPtr的open内的参数设定如下:
this->m_pRecrod->Open(sql,this->m_pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
sql语句如下:
_bstr_t sql="select state from authors group by state";
请教解决办法。。
this->m_pRecrod->Open(sql,this->m_pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
sql语句如下:
_bstr_t sql="select state from authors group by state";
请教解决办法。。
我试过了,SQL SERVER 数据库下面的代码没有问题,正确取出了数据。======================================== pRs->Open("select state from authors group by state",
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText); _variant_t var;
CString str; var = pRs->GetCollect("state");
str = (LPCTSTR)(_bstr_t)var; MessageBox(str);========================================