Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Next 25 Records
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
![]() |
![]() |