[Q] Passing data between forms in multiple form app
Date: 1995/04/01
Message-ID: <3ljc0p$2ed_at_news.rhrz.uni-bonn.de>#1/1
Hello.
We use Forms 4.5.3 and we are about to test the new multiple form
application feature withthe open_form built-in.
Our question is:
Suppose, we a form A, in which we select a certain number of records via a checkbox (form_A contains a multiple record block and a non-database item 'selected', which is a checkbox with the two values 'T' and 'F'). When calling form_B, the id-numbers of the selected records should be passed to form_B in any way.
We already considered the following ideas:
- We concatenate the id-numbers into one string and pass the string to form_B
via a char parameter. Since char parameters can only be 255 characters long,
we could only save up to 50-80 id-numbers. This is too small in our case.
- We put the selected id-numbers in a temp table. But then we have to commit each time we call the new form. We don't want that.
Any idea?
Informational background:
We use the id-numbers in form_B for modifying the WHERE-Statement in a
multiple-record block. Only the details of the selected id's should be
displayed in this block.
BTW, a suggestion to Oracle:
With the run_product built-in, one can pass a record group to Reports or
Oracle Graphics. Why not with Forms and the open_form built-in?
Thanks in advance,
Dirk.
-- Dirk Moebius moebius_at_informatik.uni-bonn.de Application Development BAYER AG, Leverkusen GermanyReceived on Sat Apr 01 1995 - 00:00:00 CEST