记录集不能直接读取,要先判读EOF或者BOF,可以看下这个例子,或者向下面这样改一下,用COUNT来计算个数。 CString sql; _variant_t value; sql.Format("select COUNT(hw_id) AS hwidcount from tabhwinfo where hw_id='%s'",m_wlbm); m_runsql.CheckSQLResult(sql); value=m_runsql.m_recordset->GetCollect((long)0); long nCount = (long)value;
CString sql;
_variant_t value;
sql.Format("select COUNT(hw_id) AS hwidcount from tabhwinfo where hw_id='%s'",m_wlbm);
m_runsql.CheckSQLResult(sql);
value=m_runsql.m_recordset->GetCollect((long)0);
long nCount = (long)value;