Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Next 25 Records

Re: Next 25 Records

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Mon, 8 Mar 1999 16:33:34 -0000
Message-ID: <36e3faab.0@145.227.194.253>


If you are using Forms 4.5/5 etc, you can set the Fetched property of your block to 25. That should retrieve 25 records at a time in your block.

Mark

Stan wrote in message <36E3EC68.61D675B5_at_yahoo.com>...
>Is there a way that I could fetch the first 25 records of a infinite
>sized table, then issue a command to fetch the next 25 records?
>Basically I want to display data in a grid form. The first procedure
>would be to get the first 25 records, then if the user pressed pagedown,
>the grid would display the next 25 records. I don't want to load the
>whole table as this would be very time consuming. I only want to load
>the records that I am displaying.
>
>Thanks, Stan.
>
Received on Mon Mar 08 1999 - 10:33:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US