Re: Call REPORTS with Current Result Set

Ed,

To pass the where clause to Reports, use the system variable :SYSTEM.LAST_QUERY. This variable contains the text of the most recent SELECT statement issued by Forms. The documentation for this variable gives an example of how to extract the WHERE/ORDER BY clause from the SELECT statement.

Todd Owers

Ed Jennings wrote in message <35E3EC50.2DB126FF_at_mindspring.com>...
>To clarify the problem: I have a FORM with 18 fields displayed. I
>never know which fields the user may select to narrow the focus of the
>query. I am looking for a generic way to account for the entire where
>clause in the passed parameters to REPORTS. How do you pass the where
>clause to REPORTS?
>
>Ed Jennings
>
Received on Wed Aug 26 1998 - 15:46:11 CEST