Home » Developer & Programmer » Forms » how to pass two parameter for graphs from form (merged by CM) (forms 6i)
how to pass two parameter for graphs from form (merged by CM) [message #446134] Fri, 05 March 2010 10:31 Go to next message
mohaninforakle
Messages: 55
Registered: January 2009
Member
hai friends,

i had a chart developed by graphics builder in which I am passing one parameter(ie year) and displaying the chart.Now i want to pass two parameter into chart.How to do this here i have attached my chart view and procedure which executes and display the chart from forms.

coding when button pressed

PROCEDURE CHART_DISPLAY IS
pl_id ParamList;
pl_name VARCHAR2(100) := 'tempdata';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF not Id_Null(pl_id) THEN
destroy_parameter_list(pl_id);
end if;
pl_id := Create_Parameter_List(pl_name);
/* Now add a parameter to pass to graphics*/
Add_Parameter(pl_id,'PYEAR',TEXT_PARAMETER,'2009');
/*if need more parameters, use more Add_parameter to list*/
/*now, call the graphics sal.ogd file to show on especified chart_area and with a parameter list*/
OG.open(C:\CHART\SALES_TREND.OGD','CHART.SALES_CHART',FALSE,TRUE,pl_id);
OG.close('C:\CHART\SALES_TREND.OGD','CHART.SALES_CHART');
END;


In the above procedure i had one parameter directly am passing value of year '2009' now i want to pass two parameter like between 'year1' and 'year2' for getting chart between two years.


Please somebody help me on this.

Am waiting for your reply.

thanks in advance

Re: how to pass two parameter for graphs from form (merged by CM) [message #446141 is a reply to message #446134] Fri, 05 March 2010 12:27 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Add another add_parameter call. What's the problem?
Previous Topic: display BLOB to form's image
Next Topic: formating excel..
Goto Forum:
  


Current Time: Fri Dec 09 08:11:48 CST 2016

Total time taken to generate the page: 0.08336 seconds