Home » Developer & Programmer » Forms » 1st form data display into 2nd form
1st form data display into 2nd form [message #232450] Fri, 20 April 2007 10:13 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
please see this link

http://forums.oracle.com/forums/thread.jspa?threadID=497807&tstart=0

kindly solve my problem.
Re: 1st form data display into 2nd form [message #232658 is a reply to message #232450] Sun, 22 April 2007 21:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Post your question in this forum and we will solve it.

David
Re: 1st form data display into 2nd form [message #232809 is a reply to message #232658] Mon, 23 April 2007 06:32 Go to previous messageGo to next message
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 #232884 is a reply to message #232809] Mon, 23 April 2007 15:41 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So call the second form and execute query in it. You might need to use global variable(s) or parameter(s) in order to filter fetched record set.
Re: 1st form data display into 2nd form [message #232903 is a reply to message #232884] Mon, 23 April 2007 23:48 Go to previous messageGo to next message
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;
Re: 1st form data display into 2nd form [message #233002 is a reply to message #232903] Tue, 24 April 2007 06:48 Go to previous message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Attach your forms.
I can have look at that.

Bhupinder Singh
Previous Topic: Forms 10g Matrix Layout & backward compatilibily(forms 10.1.2) (merged)
Next Topic: Using Non-DB Functions in forms
Goto Forum:
  


Current Time: Sun Dec 04 10:34:31 CST 2016

Total time taken to generate the page: 0.12260 seconds