Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 862
  • Last Modified:

CALLING FORMS form6i

can you give me the built in functions and examples of calling forms or passing parameters
0
aerokevs
Asked:
aerokevs
1 Solution
 
kretzschmarCommented:
just to ask, if you didn't have a forms-helpfile

from the forms helpfile

/* Example 1:
** Call a form in query-only mode.
*/
BEGIN
  CALL_FORM('empbrowser', no_hide, no_replace, query_only);
END;

/* Example 2:
** Call a form, pass a parameter list (if it exists)
*/
DECLARE
  pl_id        PARAMLIST;
  theformname  VARCHAR2(20);
BEGIN
  theformname := 'addcust';

  /* 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;

meikl ;-)
0
 
Mark GeerlingsDatabase AdministratorCommented:
Another way to call forms in any order that allows you to pass values in both or either direction: just use the same "call_form" command, but include the parameter "share_library_data".  You also need to create a PLL library, create a package in it where you declare some variables, attach the library to each of your forms, then before you do the "call_form" assign the value(s) you want to the package variable(s) you want.  Then the called form can check the variable(s) you want it to check in the when-new-form-instance trigger and take appropriate action. typically this would either execute a query based on the value, or set up the default(s) for data entry based on the value(s) from the package in the PLL library.
0
 
aerokevsAuthor Commented:
markgeer,
      can you give me an example using codes?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now