Is it possible to make another SQL query AFTER the CRecordset open statement.
I know that it is possible to use the
m_strFilter (to add a where statment) and the m_strSort
(for a ORDER BY statement). Then by calling the requery, the CRecordset instance will be updated accordingly.
But if you want to carry out a Select Count(*) followed by a Select <Column>, is this possible to do this with out closing and reopening the Crecordset instance with the appropriate query string and to not use any API functions.