passing TWO parameters between two forms [message #475821] |
Fri, 17 September 2010 18:32 |
ramboil3arab
Messages: 4 Registered: July 2010 Location: Palestine
|
Junior Member |
|
|
Dear Everybody
I reallly need your help in this. I am a begginner in oracle and forms. I'm using Forms 10g, and would appreciate any help...
I need to pass two parameters (STUD_ID) and (TERM) from Form A to Form B.
I've read alot but I'm not familiar with terms and oracle jargon yet! So I really need your straight forward clarification
From the Calling form I'm using when_button_pressed trigger...what shall i write in here?!
In the Called form, I'm declaring the following under (When_new_form-instance):
declare
p1_id paramlist;
stud_id number(8);
term number(5);
begin
p1_id := get_parameter_list(stud_id);
p1_id := get_parameter_list(term);
:TEST_STUD_CRSE_REG.stud_id :=:parameter.stud_id;
:TEST_STUD_CRSE_REG.term :=:parameter.term;
next_block;
end;
-----------------
on the calling form:when_button_pressed I am using:
DECLARE
p1_id paramlist;
stud_id number(8);
term number(5);
BEGIN
call_FORM('test16SEP',NO_HIDE);
GO_BLOCK('TEST_STUD_CRSE_REG');
set_block_property('TEST_STUD_CRSE_REG',default_where,'STUD_ID=:TEST_STUDENT_INFO.STUD_ID');
execute_query;
END;
thank you veryyyyyy much ALL
|
|
|
|
|