This is just a simplified example. There are multiple input
parameters and the where clause will get more complex. Do I have to
live with having the stored procedure check every record in my example?
First,
check if what you want to do can be done by other means, supposedly by
changing the
I forgot to mention I'm using firebird 1.5.5
1) The integer was a typo.
2) The stored procedure in your reply, it's looping through every record
correct?
I guess my question wasn't very clear. What I'm trying to do is have
conditional logic in the where clause.
pseudo code:
Select * from