将数据插入List1表中,如有相同的记录,则只需更新Number字段
void CMDMView::LFV_combineRecord(CString LOS_size, CString LOS_use, int LVI_iNumber)
{
_variant_t LOS_strSql;
CString LOS_number;
int LVI_iCount=0;
LOS_strSql = "select * from List1 where Size = '" + LOS_size + "' and Use = '" + LOS_use + "'";
theApp.ADOExecute(theApp.m_pADOSet1, LOS_strSql);
LVI_iCount = theApp.m_pADOSet1->GetRecordCount();
if (LVI_iCount > 0) //List1表中存在该记录,则只要更新Number即可
{
LOS_strSql = theApp.m_pADOSet1->GetCollect("Number");
LOS_number.Format("%d", LOS_strSql.iVal + LVI_iNumber);
LOS_strSql = "update List1 set Number = '" + LOS_number + "'where Size = '" + LOS_size + "'and Use = '" + LOS_use + "'";
theApp.ADOExecute(theApp.m_pADOSet1, LOS_strSql);
}
else//List1表中不存在该记录,则插入该记录
{
LFV_refreshFilter(LVI_iNumber);
}
}
以上的源代码,每当运行时,就提示"ADO ERROR(null)"的错误
LFV_refreshFilter(LVI_iNumber)这个函数是正确的;
请大家帮忙看看 谢谢了 解决了马上给分