CString sql="SELECT * from dlu where dluid='"+m_s_dluid+"'";
CString strSQL; strSQL.Format(_T("SELECT * from dlu where dluid=%s"),m_s_dluid); m_pRecordset->Open(strSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText); "SELECT * from dlu where dluid=m_s_dluid"不能把 m_s_dluid放在引号里面,放里面了就不是一个变量了,是一个字符串,要用%s转换
为什么 我按照你的这个做了之后 他编译出错 提示 error C2664: 'Open' : cannot convert parameter 1 from 'class CString' to 'const class _variant_t &' Reason: cannot convert from 'class CString' to 'const class _variant_t'
CString strSQL;
strSQL.Format(_T("SELECT * from dlu where dluid=%s"),m_s_dluid);
m_pRecordset->Open(strSQL,
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText); "SELECT * from dlu where dluid=m_s_dluid"不能把 m_s_dluid放在引号里面,放里面了就不是一个变量了,是一个字符串,要用%s转换
error C2664: 'Open' : cannot convert parameter 1 from 'class CString' to 'const class _variant_t &'
Reason: cannot convert from 'class CString' to 'const class _variant_t'