_commandPtr 的execute()方法

[程旭元]

pCommand.CreateInstance("ADODB.Command");
pCommand->ActiveConnection=pConnection;
pCommand->CommandText="select count(*) from testtable";
_variant_t vt;
pCommand->Execute(&vt,NULL,adCmdText);
cout<<vt.intVal <<endl ;

vt.intval的值怎么老是-1？怎么才能得到影响的行数？

[mo229mo]

pCommand.CreateInstance("ADODB.Command");
pCommand->ActiveConnection=pConnection;
pCommand->CommandText="select count(*) from testtable";
---------------------------------------------------------------
//pCommand->Execute(&vt,NULL,adCmdText);
改为：
_RecordsetPtr m_pRecordset=pCommand->Excute(NULL,NULL,adCmdText);
_variant_t vt;
vt=m_pRecordset->getCollect((_variant_t)(long)0);
m_pRecordset->Close();
----------------------------------------------------------------

cout < <vt.intVal < <endl ;