Home » Developer & Programmer » Forms » how use parameters in form? (6i)
how use parameters in form? [message #532251] Mon, 21 November 2011 12:14 Go to next message
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
Re: how use parameters in form? [message #532262 is a reply to message #532251] Mon, 21 November 2011 12:34 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
./fa/1774/0/ zzzzzz

Regards
Michel
Re: how use parameters in form? [message #532264 is a reply to message #532251] Mon, 21 November 2011 12:59 Go to previous messageGo to next message
joy_division
Messages: 4490
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 Go to previous messageGo to next message
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????????????
Re: how use parameters in form? [message #532318 is a reply to message #532307] Tue, 22 November 2011 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 19350
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.
Re: how use parameters in form? [message #532329 is a reply to message #532307] Tue, 22 November 2011 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
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????????????


./fa/7257/0/??????????

Re: how use parameters in form? [message #598445 is a reply to message #532329] Tue, 15 October 2013 00:25 Go to previous message
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;
Previous Topic: How to create folder dynamically using Oracle Form 6i
Next Topic: Starting Reports with Forms and suppress empty reports
Goto Forum:
  


Current Time: Fri Aug 01 19:46:03 CDT 2014

Total time taken to generate the page: 0.09589 seconds