Block Records Page Down [message #407094] |
Mon, 08 June 2009 07:29  |
nitinreddy
Messages: 2 Registered: June 2009 Location: US
|
Junior Member |
|
|
I created a block based on a table. I put 'No of Records Displayed' as 15. When I press page down key, 12 new records are displayed. I expect, last record has to be displyed as first and another 14 new records has to be displayed. When I put 'No of Records Displayed' as 25, 20 new records are displayed, instead of 24. Please help me which property I need to change.
Advance Thanks.
|
|
|
|
Re: Block Records Page Down [message #407159 is a reply to message #407100] |
Mon, 08 June 2009 15:33   |
nitinreddy
Messages: 2 Registered: June 2009 Location: US
|
Junior Member |
|
|
Thanks for the your reply.
Yes, it is multiple record block. As specified in 'No of Records Displayed', the block is showing those many records. When I press Page Down key, I expect, last record should be showing as first and another new records should be shown below.
I have to work with Forms 6i, as I am oracle applicatons 11i developer. When I put 5, it is showing 5 records. When I press Page Down key, last record is first records and another 4 new records are shown. Most of oracle application screens are with 5 records and user never have such issue. But I need to create a block with 25 records. I put 25 and press Page Down key, last record becomes as 5th record, and another 20 new records shown.
If any body faced this issue, please help me in giving tip.
Thanks.
|
|
|
Re: Block Records Page Down [message #408562 is a reply to message #407159] |
Tue, 16 June 2009 20:16  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I believe that you are operating under a misconception. There is no Page_Up or Page_Down in Oracle Forms, there is a Scroll_Up and a Scroll_Down.
I had a discussion on this point with the Oracle developers many years ago and their philosophy was that AT LEAST the last record was displayed at the top of the next retrieved set but that as the number of rows displayed increased there would be more 'previous' rows displayed up to a maximum of three.
If you don't like this behaviour then add your own 'Scroll' trigger code and do a specific number of 'down' or 'up' commands.
David
|
|
|