Solved

CALLING FORMS form6i

Posted on 2002-04-18
3
846 Views
Last Modified: 2010-05-18
can you give me the built in functions and examples of calling forms or passing parameters
0
Comment
Question by:aerokevs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 6950455
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
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 6950947
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
 

Author Comment

by:aerokevs
ID: 6959541
markgeer,
      can you give me an example using codes?
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question