I am working with VB 6.0 and ADO 2.0 with back-end Database as ORACLE 8.
I want fetch data from an Oracle Table in a particular range ,say 200 records into a Recordset Object. The table has approx. 43,000 rows.
i.e., I have to load first 200 record, then next 200 and so on ........... without closing the Recordset for subsequent fetching.

CAN ANY BODY HELP ME OUT ?
THANKS IN ADVANCE.