> Ah, yes, didn't think of that.
> Any idea roughly how many characters that will be?

~ 64K characters, if your SQL text is using a 1 byte per character
encoding, and possibly less for a multi-byte enconding, although I'm not
entirely sure if this applies in that area.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

> RBS
>
>
> On Mon, Jul 16, 2012 at 2:37 PM, Thomas Steinmaurer <ts@...>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.
>>
>> Perhaps you hit the limit of a single SQL statement text, which is ~64KB.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>