ADO不能从Oracle中正确读出数值型数据

[lr78316]

_variant_t temp;

strSql="select jhdh from jjbsjb where jm='"+WellName+"'";

temp=m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,1)
->GetCollect"jhdh");

temp读出为0

[lr78316]

m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,1)返回的是m_pRecordset

[zhangnanonnet]

你是不是用错了阿

应该是
_RecordsetPtr m_pRecordset;
_variant_t vIndex = (long)0;

m_pRecordset ＝ m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,1)
->GetCollect"jhdh");


if (m_pRecordset->adoEOF)
{
sRet = "";
}
else
{
tmp = m_pRecordset->GetCollect(vIndex);
}

[lr78316]

_variant_t temp;

strSql="select jhdh from jjbsjb where jm='"+WellName+"'";

temp=m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,1)
->GetCollect("jhdh");

temp读出为0

[zhangnanonnet]

m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,1)
->GetCollect("jhdh");

返回的是m_pRecordset

[lr80818]

使用MS ODBC FOR ORACLE作为数据源，不要用ORACLE ODBC DRIVER