OraFAQ Forum: Forms » how use parameters in form?

Home » Developer & Programmer » Forms » how use parameters in form? (6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how use parameters in form? [message #532251]

Mon, 21 November 2011 12:14

saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal

Junior Member

Hi Experts...

I want to ask that how can I use parameters in forms? I have created 2 parameter pm_rollnum and pm_classname but I don't that how I use it in form that when end user enter its value in these parameter result should be open.

waiting plzzzz.
thanks

saqib khan

Report message to a moderator

Re: how use parameters in form? [message #532262 is a reply to message #532251]

Mon, 21 November 2011 12:34

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

zzzzzz

Regards
Michel

Report message to a moderator

Re: how use parameters in form? [message #532264 is a reply to message #532251]

Mon, 21 November 2011 12:59

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Refer to them with a leading colon, as :pm_rollnum, for example.

[Updated on: Mon, 21 November 2011 13:20]

Report message to a moderator

Re: how use parameters in form? [message #532307 is a reply to message #532264]

Mon, 21 November 2011 22:32

saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal

Junior Member

Thanks for reply but I want to know where I refer them? In procedure? In sql query? In function? and how????????????

Report message to a moderator

Re: how use parameters in form? [message #532318 is a reply to message #532307]

Tue, 22 November 2011 00:09

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you don't know where and how, you most probably don't need them.

Forms Help is very well written - go open it and search for a term you are interested in, read as many articles as possible. Many of them contain examples which show you how to use certain features.

Anyway: I, for example, use parameters when I have to pass values from one form to another. They can be used in - as you said - functions, trigger, ... How? Just like Joy Division told you.

Report message to a moderator

Re: how use parameters in form? [message #532329 is a reply to message #532307]

Tue, 22 November 2011 01:01

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

saqib4882 wrote on Tue, 22 November 2011 05:32

Thanks for reply but I want to know where I refer them? In procedure? In sql query? In function? and how????????????

??????????

Report message to a moderator

Re: how use parameters in form? [message #598445 is a reply to message #532329]

Tue, 15 October 2013 00:25

krishna@6268
Messages: 3
Registered: October 2013
Location: chennai

Junior Member

DECLARE
pl_id ParamList;
a varchar2(30);
BEGIN
-- a:=:test.test;
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List(pl_id);
END IF;
pl_id := CREATE_PARAMETER_LIST('tempdata');
Add_Parameter(pl_id,'to_parameter_name', TEXT_PARAMETER,:from_:block_name.item_name);
call_form('D:\ELECTRIC.BILL\PAY_BILL' ,NO_HIDE,NO_REPLACE,NO_QUERY_ONLY,pl_id);
END;

Report message to a moderator

Previous Topic:	forms 10g, win xp 32 bit
Next Topic:	Starting Reports with Forms and suppress empty reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:29:16 CDT 2024