[Q] Passing data between forms in multiple form app

From: Dirk Moebius <moebius_at_zeus.informatik.uni-bonn.de>
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:
How can you pass a sequence of id-numbers (e.g. by a record-group) to a new form?

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
Germany
Received on Sat Apr 01 1995 - 00:00:00 CEST

Original text of this message