[SOLVED] Passing filter value to a stored procedure
Let's say that I have two tables - Cars and CarType. Cars has a CarTypeID - a foreign key field.
I wrote a stored procedure that joins Cars and CarType, it also takes one parameter - CarTypeID.
How do I create a report in InfoAssist with a filter on CarTypeDescription but passed CarTypeID to the stored procedure (I would like to filter the data by the ID instead of the description field to improve query performance)?
ThanksThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.0.7 Windows, All Outputs
August 20, 2014, 05:36 PM
AmiSol
I realized that the way to do it is by using the accept - FOCEXEC option in the master file to reference a lookup procedure