错在哪里??ADO Excute()

Question

_variant_t RecordsAffected;
CString sql;
var=m_pRecordset->GetCollect("Angle_id");//获得id
sql="insert into Test(ID,Angle_id) values(1,(_bstr_t)var)";
if(var.vt!=VT_NULL)
theApp.m_pConnection->Execute(_bstr_t (sql),&RecordsAffected,adCmdText);
m_pRecordset->Close();

Answer 1

sql="insert into Test(ID,Angle_id) values(1,(_bstr_t)var)";
改成
sql="insert into Test(ID,Angle_id) values(1,(_bstr_t)'"+var+"')";

Answer 2

sql="insert into Test(ID,Angle_id) values(1, " + var + ")";

Answer 3

CString sql;
var=m_pRecordset->GetCollect("Angle_id");//获得id
         var.ChangeType(VT_BSTR);
CString str_var=var.bstrVal;
sql="insert into Test(ID,Angle_id) values(1, " + var + ")";
if(var.vt!=VT_NULL)
theApp.m_pConnection->Execute(_bstr_t (sql),&RecordsAffected,adCmdText);
m_pRecordset->Close();