Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing Arguments in Forms - Newbie
Hi Kevin,
Forget about the parameter-list, you do not need such a thing here.
Calling FORM_A from FORM_C you could do it like this:
In FORM_C you’ll have a trigger calling FORM_A
If the value you need to populate FORM_A with is in a current row in your
FORM_C
You’ll write the following code:
Of course if the desired value comes from some calculation you can fill the global with the variable that contains the calculation.
Then in FORM_A you’ll need the following two triggers:
A when-new-form-instance trigger::
If get_application_property (calling_form) = ‘FORM_C’
Then
Execute_query;
End if;
A pre-query trigger:
If get_application_property (calling_form) = ‘FORM_C’
Then
:Block_in_A.item_in_A := :global.you_name_it; end if;
This should work,
Good luck
Olga Greep
Kevin Hughes wrote in message <38D210DF.AE812E87_at_bangor.ac.uk>...
>I have a form (FORM A) which I can call from two other forms FORM B and
>FORM C.
>
>If I call it from FORM B it needs to be blank i.e. so that I can insert a
>new record. (This i've managed). However if i call FORM A from FORM C
>i need all the fields to be populated based on a value on FORM C. This will
>be for an edit / update of the record.
>
>I assume that I need to create a parameter list, use the add_parameter
>built in to add the paramater to the list and then pass this through the
>call_form built in to the called form.
>
>I'm a bit confused on a number of issues.
>
>1. What is the correct syntax for adding data parameters to a list.
>2. What are the implications of calling a form both with and without a
>parameter list(i.e. From FORM C and B)?
>3. Will i need to change anything in the called form?
>
>I hope the above is clear.
>Thanks in advance for any help you can give.
>
>--
>J. Kevin Hughes j.k.hughes_at_bangor.ac.uk
>Administrative Computing
>University of Wales - Bangor
>Adeilad Deiniol
>Ffordd Deiniol / Deiniol Road
>Bangor LL57 2UX
>Tel: (01248) 382373 Fax: (01248) 383826
Received on Sat Mar 18 2000 - 08:10:54 CST
![]() |
![]() |