Home » Developer & Programmer » Forms » Call_form with parameter
Call_form with parameter [message #80173] Mon, 19 August 2002 06:47 Go to next message
aish
Messages: 44
Registered: March 2001
Member
I want to call one form from another and I want customer id as my parameter,where customer id is a block item.
I want to take this customer id as input parmeter and call a form and called form should display the screen for that custoer id
How do I do that?
Re: Call_form with parameter [message #80175 is a reply to message #80173] Mon, 19 August 2002 12:30 Go to previous message
Bob
Messages: 49
Registered: March 1999
Member
/*

** Built-in: CALL_FORM
** Example: Calls a form, passing a parameter list if the
** parameter list exists.
*/
DECLARE
pl_id ParamList;
theFormName VARCHAR2(20) := 'addcust';
BEGIN
/*
** Try to lookup the 'TEMPDATA' parameter list
*/
pl_id := Get_Parameter_List('tempdata');
/*
IF Id_Null(pl_id) THEN
Call_Form(theFormName);
ELSE
Call_Form(theFormName, HIDE, NO_REPLACE, NO_QUERY_ONLY,
pl_id);
END IF;

Call_Form('lookcust',NO_HIDE,DO_REPLACE,QUERY_ONLY);
END;

Copyright (c) 1994, Oracle Corporation.

/*

** Built-in: ADD_PARAMETER
** Example: Add a value parameter to an existing Parameter
** List 'TEMPDATA', then add a data parameter to
** the list to associate named query 'DEPT_QUERY'
** with record group 'DEPT_RECORDGROUP'.
*/
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Add_Parameter(pl_id,'number_of_copies',TEXT_PARAMETER,'19');

Add_Parameter(pl_id, 'dept_query', DATA_PARAMETER,
'dept_recordgroup');
END IF;
END;

Copyright (c) 1994, Oracle Corporation.
Previous Topic: Error in library file opening
Next Topic: How to connect Form builder to Oracle
Goto Forum:
  


Current Time: Sun Sep 19 12:10:50 CDT 2021