Subject RE: [firebird-support] Re: Conditional conundrum
Author Rick Debay
(unit_use in ('U') and :param in ('U')) or
(unit_use not in ('U') and :param not in ('U'))

The portion of the query that tests a parameter against a value isn't supported in Firebird.

-----Original Message-----
From: [] On Behalf Of Ali Gökçen
Sent: Thursday, October 20, 2005 1:02 PM
Subject: [firebird-support] Re: Conditional conundrum

Hi Rick,
I couldn't be sure about your problem and my solution..
Can you paste your real query here?


--- In, "Rick Debay" <rdebay@r...>
> I have a not-null char(1) field that can be 'U' or some other
value. I
> also have a stored procedure, that among other things needs to
> items based on a char(1) parameter.
> The pseudo-SQL is:
> Select * from table where (Field in ('U') and :param in ('U')) or
> not in ('U') and :param not in ('U'))
> Parameter tests aren't legal to the planner ( 'Z' not in ('U') ),
and I
> can't branch to execute one query or another. Any ideas for a
> conditional statement for the WHERE clause?
> Thanks, Rick DeBay

------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today!


Visit and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links