|
|
|
|
| Re: 1st form data display into 2nd form [message #232809 is a reply to message #232658] |
Mon, 23 April 2007 06:32   |
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
|
Senior Member |
|
|
Dear David
I have 2 from
1. abc
2. xyz
abc form has 2 blocks and both are database block.
xyz form has 1 block (just for display items of block1)
Required:
I insert record in form1 and commit, I want when I save this record 2nd form will activate and display record in 2nd form
[Updated on: Mon, 23 April 2007 06:33] Report message to a moderator |
|
|
|
|
|
| Re: 1st form data display into 2nd form [message #232903 is a reply to message #232884] |
Mon, 23 April 2007 23:48 |
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
|
Senior Member |
|
|
I write this code in commit button when-button-press trigger.
It is opening desire form but not passing value in form
-------------------------
Do_Key ('Commit_Form');
declare
pl_id paramlist;
pl_name varchar2(200) := 'abc';
begin
pl_id := Get_Parameter_List(pl_name);
IF NOT Id_NULL(pl_id) THEN
DESTROY_Parameter_list(pl_name);
end if;
pl_id := Create_Parameter_List(pl_name);
ADD_PARAMETER(pl_id,'k_cost_no',text_parameter,:sizecost.cost_no);
ADD_PARAMETER(pl_id,'kc_size', text_parameter,:sizecost.c_size);
ADD_PARAMETER(pl_id,'ksrate', text_parameter,:sizecost.srate);
ADD_PARAMETER(pl_id,'ksperc', text_parameter,:sizecost.sperc);
ADD_PARAMETER(pl_id,'kswastage', text_parameter,:sizecost.swastage);
ADD_PARAMETER(pl_id,'kstot', text_parameter,:sizecost.stot);
open_FORM ('\ORACLE\Costing\Forms\subcost');
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
