-
Recordet fetching
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.
-
Re: Recordet fetching
If you will use pagesize property of ADODB.Recocrset then this may solve the problem
-
Re: Recordet fetching
SELECT TOP 200 * from ..............
This may help you dear :-)
Santulan
-
Re: Recordet fetching
hello
I haven't Ever Seen Select TOP statement In ANSI SQL , Could you able give me the Code of the SQL statement
Bye