parameter problem..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: parameter problem..

  1. #1
    Join Date
    May 2001
    Location
    Pune
    Posts
    12

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width