Home » Developer & Programmer » Forms » navigable current Record (Oracle form builder 10g)
navigable current Record [message #677347] Fri, 13 September 2019 00:22 Go to next message
Atif Raza
Messages: 2
Registered: September 2019
Location: Gujrat
Junior Member
how to hide the remaining record in block and visible the current record.
Re: navigable current Record [message #677356 is a reply to message #677347] Fri, 13 September 2019 03:52 Go to previous messageGo to next message
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can't. You can hide items, you can't hide rows.
To get rid of rows you would have to actually remove them from the block by either using clear_record or by executing another query.
Re: navigable current Record [message #677429 is a reply to message #677356] Thu, 19 September 2019 14:07 Go to previous message
Messages: 21671
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you want to see only one record, why did you choose tabular layout?

Perhaps you could create yet another block which would have a form layout. Navigate to it from the current block; pass ID (or whichever column is used to uniquely distinguish records), use SET_BLOCK_PROPERTY with ONETIME_WHERE to fetch it to that single-record data block. That would be something like a "pop-up": use tabular form to view many records, pop-up a single one (perhaps even showing some additional data).
Previous Topic: forms 6i fetch data
Next Topic: Oracle Forms 6i and Patch 19
Goto Forum:

Current Time: Fri May 14 15:46:39 CDT 2021