Re: Passing Forms Query to Reports

In article <35105876.660E57A9_at_concentric.net>,   "J. A. Hallman" <hallman_at_concentric.net> wrote:
>
> Do you think there could be issues since global variables can only contain
 255
> characters? Is there another way around this?

Are you sure about this? Recently I heard a global variable can contain a maximum of 32k of data.

Kind Regards,
Theo

> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 19 1998 - 00:00:00 CET