Re: Passing VARIABLES between FORMS
From: Jim Winterroth <jwinter_at_qdrs2a.stg.trw.com>
Date: 1995/08/18
Message-ID: <412agf$g2d_at_ns1.nba.TRW.COM>#1/1
>
> I HAVE CREATED TWO FORMS IN SQLFORMS 3.0 ON ORACLE 7.0. THE FIRST FORM BRINGS
> UP CUSTOMER INFORMATION IE./ CUST_NUMBER, CUST_NAME ETC. THE USER SELECTS THE
> DESIRED COMPANY AND EXITS THE FORM WHERE THE CUST_NUMBER IS PLACED ON THE
> SCREEN. THE NEXT FORM IS THEN LOADED WHICH LOADS ALL THE JOBNUMBERS RELATING
> TO PARTICULAR CUSTOMERS. WHAT I WOULD LIKE TO DO IS TO FILTER OUT ALL THE
> JOBNUMBERS EXCEPT FOR THOSE PERTIAINING TO THE PARTICULAR CUSTOMER SELECTED IN
> THE PREVIOUS FORM. I KNOW HOW TO DO THE FILTERING IN THE FORM AS FOLLOWS;
>
<snip>
>
> WHAT I NEED TO DO IS TO STORE THE CUST_NUMBER FROM THE PREVIOUS FORM IN A
> VARIABLE(OR ANY OTHER WAY)AND TO USE IT IN THE NEXT FORM AS <__SOME VARIBLE__>
>
1) Don't exit the first form, call the second form from the first. 2) Store the appropriate values to global variables.i.e. GLOBAL.CUST := :block.cust_no;
3) in the second form create a holding block where :hold.cust_no := GLOBAL.CUST then
in the block that the user sees set the enforce key on :cust_no to :hold.cust_no.
Date: 1995/08/18
Message-ID: <412agf$g2d_at_ns1.nba.TRW.COM>#1/1
pmccarth_at_rpc.unb.ca (Patrick McCarthy) wrote:
>
>
> I HAVE CREATED TWO FORMS IN SQLFORMS 3.0 ON ORACLE 7.0. THE FIRST FORM BRINGS
> UP CUSTOMER INFORMATION IE./ CUST_NUMBER, CUST_NAME ETC. THE USER SELECTS THE
> DESIRED COMPANY AND EXITS THE FORM WHERE THE CUST_NUMBER IS PLACED ON THE
> SCREEN. THE NEXT FORM IS THEN LOADED WHICH LOADS ALL THE JOBNUMBERS RELATING
> TO PARTICULAR CUSTOMERS. WHAT I WOULD LIKE TO DO IS TO FILTER OUT ALL THE
> JOBNUMBERS EXCEPT FOR THOSE PERTIAINING TO THE PARTICULAR CUSTOMER SELECTED IN
> THE PREVIOUS FORM. I KNOW HOW TO DO THE FILTERING IN THE FORM AS FOLLOWS;
>
<snip>
>
> WHAT I NEED TO DO IS TO STORE THE CUST_NUMBER FROM THE PREVIOUS FORM IN A
> VARIABLE(OR ANY OTHER WAY)AND TO USE IT IN THE NEXT FORM AS <__SOME VARIBLE__>
>
1) Don't exit the first form, call the second form from the first. 2) Store the appropriate values to global variables.i.e. GLOBAL.CUST := :block.cust_no;
3) in the second form create a holding block where :hold.cust_no := GLOBAL.CUST then
in the block that the user sees set the enforce key on :cust_no to :hold.cust_no.
Note: the above is a guick guide, not the exact code. I use this quite frequently.
Jim
<standard disclaimer applies>
Received on Fri Aug 18 1995 - 00:00:00 CEST