Subject | Re: [firebird-support] limit to number of OR conditions in a where clause |
---|---|
Author | Alan J Davies |
Post date | 2012-07-16T14:01:40Z |
I think you want to change the way you look at this - how do you manage
to control/check it? I can only imagine its a stored procedure. In which
case (no pun intended) you should be able to pass a variable and take
action accordingly. I can't remember if the "execute statement" ability
was in 1.5 but that's another option.
I know this doesn't answer your question, but may help with a different
way of thinking. (and I'm not trying to be a smart-a***)
Regards
Alan
Alan J Davies
Aldis
to control/check it? I can only imagine its a stored procedure. In which
case (no pun intended) you should be able to pass a variable and take
action accordingly. I can't remember if the "execute statement" ability
was in 1.5 but that's another option.
I know this doesn't answer your question, but may help with a different
way of thinking. (and I'm not trying to be a smart-a***)
Regards
Alan
Alan J Davies
Aldis
On 16/07/2012 14:33, Bart Smissaert wrote:
> Firebird 1.5 classic on Windows.
> Is there a limit to the number of OR conditions you can put in a where
> clause?
> It looks there is as I get unexpected end of command when there are
> some 2000 ors, but
> maybe that is due limitations of the control holding the SQL. I found
> some 150 ors is still fine.
>
> RBS
>
>