?
Solved

FORMS 6i- how do I pass values from one form to another

Posted on 2003-02-20
2
Medium Priority
?
1,705 Views
Last Modified: 2013-12-12
I have two forms:  FORM1   does a call_form to FORM2.

What i want to do is to pass a value called V1 that was calculated in FORM1 over to FORM2.


HOW DO I PASS VALUES BETWEEN FORMS?
0
Comment
Question by:joekeri
[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
2 Comments
 
LVL 4

Accepted Solution

by:
stemu2000 earned 75 total points
ID: 7989743
you have to use paramlists:


PROCEDURE RunForm IS
  pl_id ParamList;
BEGIN
  pl_id := Get_Parameter_List('tmpdata');
  IF NOT Id_Null(pl_id) THEN
    Destroy_Parameter_List( pl_id );
  END IF;
  pl_id := Create_Parameter_List('tmpdata');
  Add_Parameter(pl_id, 'P_V1', TEXT_PARAMETER, v1);
  CALL_FORM('MYFORMNAME',
              hide,
              no_replace,
              no_query_only,
              pl_id);
END;




Cheers, Stefan
0
 

Expert Comment

by:mody
ID: 7996579
i agree with Stemu2000 ,and u can in form1 set global varicable say v:
(in form1 any area of code)
:global.v:=<certain_value>
and when u use call form
form2 will see this global variable
form2
x:=:global.v;
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

777 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