Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic BLOCK Display

594488Oct 3 2007 — edited Nov 15 2008
Hi,

I want to know if this option is do able, with code?

here's the scenario:

1) user enters the form.
2) select what he wants to SEARCH for (radio button).
3) Then a block will be drawn (displayed) in the form bassed on what he selected.

Now, when I code the form, I would define the BLOCKS needed.

Is it possible (with the help of SET_BLOCK_PROPERTY) to display (draw) the block that the user selected?

Thanks in advance,

Marc.

Comments

450441
Sounds like this is a job for.... Stacked Canvases!

Put each block that might be selected on a different canvas, and SHOW_VIEW based on the radio button.

Although most design philosophies would suggest that if you're querying different sources, maybe you need to be in different forms.
594488
Thanks,

I'll give this a try.

Marc.
594488
The problem is that I have TABS. How will this work with STACKED canvases?

Marc.
450441
You can put a stacked canvas on top of a tab quite happily - indeed, it's recommended in some cases - when you query on a tabbed form it gets all the data for all the tabs. If you use stacked canvases for the tabs contents, it doesn't retrieve them until the canvas is displayed (i.e. the tab is selected - an extra line in WHEN-TAB-PAGE-CHANGED to SHOW_VIEW)
user346369
Marc, I have a form that does that -- you select a table, and it builds a block for every column in the table, like a spread sheet. You can then display and update the data.

<p>Here is the web site describing it:<br>
QA - Quick Access utility form.

<p>Some of the web site documentation has not been updated, but it works perfectly with Forms 6i and 10g, with dbms versions 8, 9 and 10.

<p>If you want, I can send the fmb. Just email me (address is in my profile).

Edited by: Steve Cosner on Nov 14, 2008 9:44 PM -- website change
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2007
Added on Oct 3 2007
5 comments
687 views