Re: Passing Forms Query to Reports

From: J. A. Hallman <hallman_at_concentric.net>
Date: 1998/03/18
Message-ID: <35105876.660E57A9_at_concentric.net>#1/1


[Quoted] Do you think there could be issues since global variables can only contain 255 [Quoted] characters? Is there another way around this?

DanHW wrote:

> >I have a V4.5 Form which contains a Master and Detail table. I would
> >like to allow the users to query using QBE as provided by Oracle. Once
> >the data is retrieved, pass it to Reports V2.5 if the user presses a
> >Print button. I've tried using :SYSTEM.Last_Query. This works OK util
> >you view the records. As you move from record to record the detail
> >table is queried. This updates :SYSTEM.Last_Query. Is there a way to
> >print the current Forms query set in Reports?
> >
> >Thanks
> >Jeff Hallman
> >hallman_at_concentric.net
> >
> >
> On the Post-query trigger on the master block, save the :SYSTEM.LAST_QUERY in a
> global or a parameter. Pass this to the report via a parameter.
>
> Dan
Received on Wed Mar 18 1998 - 00:00:00 CET

Original text of this message