Forum Stats

  • 3,814,940 Users
  • 2,258,933 Discussions
  • 7,892,892 Comments

Discussions

Categories

Dynamic BLOCK Display

594488
594488 Member Posts: 292
edited Nov 15, 2008 12:45AM in Forms
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.
Tagged:
· Share on TwitterShare on Facebook

Comments

  • 450441
    450441 Member Posts: 2,525
    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.
    · Share on TwitterShare on Facebook
  • 594488
    594488 Member Posts: 292
    Thanks,

    I'll give this a try.

    Marc.
    · Share on TwitterShare on Facebook
  • 594488
    594488 Member Posts: 292
    The problem is that I have TABS. How will this work with STACKED canvases?

    Marc.
    · Share on TwitterShare on Facebook
  • 450441
    450441 Member Posts: 2,525
    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)
    · Share on TwitterShare on Facebook
  • user346369
    user346369 Member Posts: 4,217
    edited Nov 15, 2008 12:45AM
    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
    · Share on TwitterShare on Facebook
This discussion has been closed.