Link to home
Start Free TrialLog in
Avatar of NiceMan331
NiceMan331

asked on

oracle open form with parameter

hi
i have form open within a button of another form passing a value to open as the follwoing :\
1-st form

 COPY(null,'GLOBAL.form_id');
  :global.form_id := rec_id;
   CALL_FORM('PO');

Open in new window

PO form
If :global.form_id is not null then
v_ID_where := 'po_id = ' || :global.form_id;
Set_block_property('PO_M', default_where, v_ID_where);
go_block('PO_M');
Execute_Query;
ERASE('GLOBAL.form_id');

Open in new window


the form called ok when it open from the 1st form , but when i open po form alone , it sent error message that variable not found
Avatar of NiceMan331
NiceMan331

ASKER

I forget to say that the code in second form written for : when new form instance trigger
ASKER CERTIFIED SOLUTION
Avatar of flow01
flow01
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Setting default value when created in the 1st form ?
OK , Done