Home » Developer & Programmer » Forms » Block Records Page Down (Oracle Forms)
Block Records Page Down [message #407094] Mon, 08 June 2009 07:29 Go to next message
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 #407100 is a reply to message #407094] Mon, 08 June 2009 07:45 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Number of records displayed" property defines how many records are visible on the screen at a time. If you set it to "1", you'll have only one record; more than "1" creates a multi-record block, so (for example) "15" makes 15 records visible.

I have never thought of the "Page up/down" problem as you have described it so - no idea. Is there any property which will make your wishes come true? I don't know, but I doubt it.
Re: Block Records Page Down [message #407159 is a reply to message #407100] Mon, 08 June 2009 15:33 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Oracle forms tutorials (merged 4)
Next Topic: System Internal sound like (Bell) In Form
Goto Forum:
  


Current Time: Sat Feb 15 12:18:20 CST 2025