Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how to pass parameter and receive that paramter in pages (APEX 3.1.2, Oracle database 10g release 2, XP professional)
how to pass parameter and receive that paramter in pages [message #385228] Sun, 08 February 2009 01:25 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

can any one help me pls how to pass parameter from one page to another page.


its very urgent please.


Thank you.

-kamal hossain
Re: how to pass parameter and receive that paramter in pages [message #385240 is a reply to message #385228] Sun, 08 February 2009 03:36 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

it is a very easiest task in apex. you shall assign the value for other page variable or you shall call other page variable value through before header process can be set. Try it. if not possible i will give detailed reply tomorrow since i am moving out very urgently.
yours
dr.s.raghunathan
Re: how to pass parameter and receive that paramter in pages [message #385241 is a reply to message #385240] Sun, 08 February 2009 03:47 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Thank you very much for your reply.


here problem is i can send parameter but still i dont know how to receive this parameter in called form/page for query.


thank you.

-kamal hossain.
Re: how to pass parameter and receive that paramter in pages [message #385285 is a reply to message #385241] Sun, 08 February 2009 23:38 Go to previous messageGo to next message
andi_raj
Messages: 55
Registered: February 2008
Member
hi,
use on load before header.
raj
Re: how to pass parameter and receive that paramter in pages [message #385391 is a reply to message #385228] Mon, 09 February 2009 06:29 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
What do you mean by pass parameter? How do you mean by receive this parameter? Do you want to set the value of an item on another page? (Then you can just simply set that item equal to the value you want by using a process, computation or branch)
Re: how to pass parameter and receive that paramter in pages [message #385423 is a reply to message #385241] Mon, 09 February 2009 09:43 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
dear kamal Hossain,

you do the following and you can understand the modalities of setting the value.

create two pages (blank form) as page 10 and page 11.

In Page 10 create two text item as p10_xx, p_10_yy
In Page 11 create one text item as p11_zz.

The following two objectives need to be done.

1. If i enter 1 in p10_xx, the value 'one' should be displayed in p10_yy. if any other value other than 1 is entered in p10_xx then 'others' should get displayed in p10_yy.

2. When i run the page 11, p11_zz should display the value stored in p10_yy.

First thing in page 10 you select the property of p10_xx as text_field ( always submit when enter pressed) instead of mear text_field.

This will facilitate, any value type in this item (p10_xx) and pressing enter will fire submit.

Now you write a process on submit after computation and validation) (Once per session)
declare
avar varchar2(30);
begin
if :p10_xx = 1 then
avar := 'one';
else
avar := 'others';
end if;
:p10_yy := avar;
end;

edit the branch process give the following values against the labels mentioned below:
Target is a ==> Page in this application
Page ==> 10
set these items ==> p11_zz
with these values ==> &p10_yy.

Now try to run page 10 you can find values in p10_yy. Now run page 11 you will find the values of p10_yy in this present page against p11_zz

Hope, i have clarrified your doubt.

best of luck,
yours
dr.s.raghunathan

[Updated on: Mon, 09 February 2009 09:45]

Report message to a moderator

Re: how to pass parameter and receive that paramter in pages [message #385673 is a reply to message #385423] Tue, 10 February 2009 08:40 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

dear mr. dr.s.raghunathan,

Thank you very much again for your continuous support.
i think i am clear now about my doubt.

i hope i will successful now using this technique.


Thank you.


-Kamal hossain


Previous Topic: Merging Applications
Next Topic: Firefox / mod_plsql error
Goto Forum:
  


Current Time: Mon Mar 18 23:43:06 CDT 2024