Recordet fetching

[joy@work]

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.

[Arun Sahoo]

If you will use pagesize property of ADODB.Recocrset then this may solve the problem

[santulan]

SELECT TOP 200 * from ..............
This may help you dear :-)


Santulan

[joy@work]

hello
I haven't Ever Seen Select TOP statement In ANSI SQL , Could you able give me the Code of the SQL statement
Bye