VC 中SQL语句的异常

[richardjackson]

_bstr_t vSQL2 ="UPDATE SendingSmsTable SET NewFlag=0 WHERE SmsIndex="+vsmsIndex.lVal;
_bstr_t vSQL3 = "UPDATE SentSmsTable SET SentSetIndex="+sendport;
_bstr_t vSQL31 =",Status=Status+1 WHERE SmsIndex="+vsmsIndex.lVal;
_bstr_t vSQL32 = vSQL3 + vSQL31;

m_AdoConn.ExecuteSQL(vSQL2);
m_AdoConn.ExecuteSQL(vSQL32);

在Debug 单步调试中发现vSQL2的值为{"PDATE SendingSmsTable SET NewFlag=0 WHERE SmsIndex=" (1)}
vSQL32的值为vSQL32为{"ATE SentSmsTable SET SentSetIndex=" (1)}

请大家帮忙解决和分析一下哈，非常感谢！

[richardjackson]

对不起，上面的是vSQL3为{"ATE SentSmsTable SET SentSetIndex=" (1)}

[shakaqrj]

格式化字符串
不用用_bstr_t类型 加上整型

[richardjackson]

哦，非常感谢！