==Crecordset 如何取得select出来的行数？

[blackwind]

m_set->Open(CRecordset::dynaset,(LPCTSTR)SqlStr);
if(m_set->GetRecordCount()>1);
{
....
}

以上做法，GetRecordCount()的值一直是1，其实表里有多条记录。
如何取得实际的记录条数？？？
{

[aa3000]

he record count is maintained as a "high water mark," the highest-numbered record yet seen as the user moves through the records. The total number of records is only known after the user has moved beyond the last record. For performance reasons, the count is not updated when you call MoveLast. To count the records yourself, call MoveNext repeatedly until IsEOF returns nonzero. Adding a record via CRecordset:AddNew and Update increases the count; deleting a record via CRecordset::Delete decreases the count.

[blackwind]

GetRecordCount()取不出来，还有什么办法？

[kugou123]

CString str="select count(*) as a from TableA";
m_pRst->Open(_variant_t(str),...,...);
_variant_t vtAmount=m_pRst->GetCollect("a");