I'm working on an interface for our reports. The source of the reports
are recordsets. Currently, the sql statements are embeded in the
program. To run a report, our users select several criteria and show
the report based on the criteria built. I'm thinking of creating a sp
to return the recordset. One problem I would encounter with sp is that
the parameters have to be OR-ed.
For instance, my sp requires two parameters, state and id. If they want
to run by:
(state = CA and id = 12) or (state = TX and id 40).
How would would I make my parameters to be OR-ed.
Should I just create a COM-component?
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.