Pass Through Query with prompts?

[mrtroy]

Is it possible to create a pass through query that uses prompts so that when the user runs the report, the user is prompted and the query uses the parameters input? (I'm using a pass-through because I need it to be read only)

Troy

 

[PHV]

I'm afraid passthru query can't be parametized...
To make a query read only, simply use the DISTINCT predicate:
SELECT DISTINCT .....

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244