CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. September 17th, 1999, 11:01 PM #1
    joy@work
    joy@work is offline Junior Member
    Join Date
    Sep 1999
    Posts
    12

    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.

    Reply With Quote Reply With Quote
  2. September 23rd, 1999, 12:21 AM #2
    Arun Sahoo
    Arun Sahoo is offline Junior Member
    Join Date
    Sep 1999
    Posts
    11

    Re: Recordet fetching

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


    Reply With Quote Reply With Quote
  3. September 23rd, 1999, 12:32 AM #3
    santulan
    santulan is offline Member
    Join Date
    Aug 1999
    Location
    India-Delhi
    Posts
    106

    Re: Recordet fetching

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


    Santulan
    Reply With Quote Reply With Quote
  4. September 24th, 1999, 11:56 PM #4
    joy@work
    joy@work is offline Junior Member
    Join Date
    Sep 1999
    Posts
    12

    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


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured