Re: Passing VARIABLES between FORMS

In <40tau5$si4_at_sol.sun.csd.unb.ca>, pmccarth_at_rpc.unb.ca (Patrick McCarthy) writes:
>
>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;
>
> DEFINE BLOCK
>
> NAME = rpcs_jobnumber
> DESCRIPTION = rpcs_jobnumber
> TABLE = rpcs_jobnumber
> ROWS_DISPLAYED = 16
> ROWS_BUFFERED = 16
> BASE_LINE = 6
> LINES_PER_ROW = 1
> ARRAY_SIZE = 0
> ORDERING = <<<
> WHERE cust_number = <___SOME VARIABLE___> ORDER BY cust_number
> >>>
>
>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__>
>
>
>ANY HELP ON THIS WOULD BE GREATLY APPRECIATED. PLEASE BE AS EXPLICIT AS
>POSSIBLE AS I AM A NEW USER.
>
>THANKS IN ADVANCE
>PATRICK MCCARTHY
>PMCCARTH_at_RPC.UNB.CA

Try using a global variable:

 :GLOBAL.CUST_NUM := :CUSTOMER_NUMBER; Received on Thu Aug 17 1995 - 00:00:00 CEST