mysql ado操作问题
ado修改数据时,Recordser update()成功,但是并没有真正修改。奇怪~
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="DRIVER={MySQL ODBC 5.1 Driver}; \
Data Source = trm_base";
try
{
HRESULT hr = pConn->Open("","","",adConnectUnspecified);
CString strSource = "select * from sys_dict \
where 类型='提醒类型' and 代码='2'";
HRESULT hr2 = pRst->Open(_variant_t(strSource),
_variant_t(pConn,true),
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch (_com_error& err)
{
CString s;
s.Format("%s",err.Description());
}
while (!pRst->ADOEOF)
{
_variant_t varIndex("名称");
_variant_t varValue("3");
pRst->PutCollect(varIndex, varValue);
HRESULT hr = pRst->Update();//hr返回0值,但是update并未起作用,数据库未被更改
return;
}