Re: [firebird-support] Re: sp case statement

2012-11-02 Thread André Knappstein
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

[firebird-support] Re: sp case statement

2012-11-01 Thread raith.daniel
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