DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: use paramlist between 2 forms

  1. #1
    Join Date
    Aug 2001
    Posts
    14
    I have 2 forms A, B. Form A call form B. I use paramlist in Form A to pass a parameter in form B (OK). My problem is how to receive the paramlist in the form B.

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    AFAIK, just create the desired parameters in the second form. So, if you need PARAM1 as char and PARAM2 as NUMBER, just create them in the Object navigator, in the node labeled "Parameters"

    []s
    Chiappa

  3. #3
    Join Date
    Apr 2001
    Posts
    51
    Suppose we have two forms dept and emp where in dept is the calling form and emp is the called form so we write the following code in dept form on the button

    declare
    list_Id ParamList;
    begin
    list_id := get_parameter_list('input_params');
    if not id_null(list_id) then
    destroy_parameter_list(list_id);
    end if;
    list_id := create_parameter_list('input_params');
    add_parameter(list_id,'d',TEXT_PARAMETER,:deptno);
    open_form('emp.fmx',ACTIVATE,NO_SESSION,NO_SHARE_LIBRARY_DATA,list_id);
    end;

    And now in the called form i.e. emp
    in when-new-form-instance write
    execute_query;

    and the pre-query trigger of the block

    deptn0 := arameter.d;

    where in this d parameter has to be created in the called form i.e. emp.

    Hope this helps u.

  4. #4
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    My suggestion is to declare global variables. You can initiate the global variables in form A, use the values in B and set the variable to the new values in B and use it A. You can use DEFAULT_VALUE builtin and PRE- AND POST-FORM triggers for this purpose.

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