This is more of a design / implementation question.
I'm writting some code that needs to implement a number of interfaces that
can be called by an external application to popualte a recordset and scroll
through it. - A guess a bit like how we use the ADO api.
The recordsets can containe between 0 and 10s of thousands of records.
Given some query information I need to be able to do the following
1) Return the TOTAL number of records
2) Return 100 rows at a time to the calling application
3) If the query is ordered by say ...