Re: Passing variables from forms 4.5 -> Reports 2.5

On 10 Feb 1998 16:40:56 GMT, dipen_at_dcs.rhbnc.ac.uk ( D. Shah) wrote:

>Hi,
>
>I am using SQL*Forms 4.5 to pass a variable to SQL*Reports 2.5 as
>follows:
>
>Run_Product(REPORTS,'receipt',ASYNCHRONOUS,runtime,FILESYSTEM,:global.booking_id,null);
>
>...now how do I USE :global.booking_id (ie variable passed over to
>SQL*Reports 2.5???
>This variable needs to be used in a SELECT clause within the 'Data
>Model' so as to
>extract specific records.
>
>(I would be very grateful if you can give me a step-by-step guide of
>what to do!).
>
>Thanks VERY much in advance!
>
>Dipen
>

You can't pass variables that way. You need to create a parameter list (which may contain several variables). See Forms 4.5 Help for creating parameter lists - they have some examples.

Good luck,

Nuno Guerreiro Received on Wed Feb 11 1998 - 00:00:00 CST