-
parameter problem..
I am new to developer6 form builder.so its a totally newbie question..
I have 2 forms , form1 and form2.I am creating a control block in form 1 and display a combobox in which I populate the list with department numbers from dept table by when_new_form_instance trigger as
DECLARE
l_deptno number;
indx number;
cursor cur_dept
is
select deptno
from dept
order by
deptno desc;
BEGIN
Set_Window_Property(FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);
Set_Window_Property('window1', WINDOW_STATE, MAXIMIZE);
indx:= 1;
OPEN cur_dept;
LOOP
fetch cur_dept into l_deptno;
if cur_dept%NOTFOUND
then
exit;
end if;
Add_List_Element('control.deptno',indx,l_deptno,l_deptno);
indx:=indx + 1;
END LOOP;
CLOSE Cur_dept;
END;
I have got a parameter as deptno in form1 and a button in form1.Upon clicking button , I want to pass this parameter to form2.
declare
list_id ParamList;
begin
list_id := create_parameter_list('passing_params');
add_parameter(list_id,'deptno', TEXT_PARAMETER, :control.deptno);
call_form('form2', NO_HIDE, NO_REPLACE, NO_QUERY_ONLY, 'passing_params');
destroy_parameter_list('passing_params');
end if;
end;
but I am not able to access this parameter in form2.Created a similar parameter deptno in form2.When I try to set access it , it says no such parameter deptno in form2. I have checked its existance and also the datatypes.
What can be the error?
Please help,
Thanks
-
Try "get" and "create" the parameter list as two steps. You should error check to see if the list is found. Once you make sure the list has been created, check to see if it was found. See Form Builder Reference, Volume I - add_parameter and create_parameter_list.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|