OK, thanks, I can look out for that and take appropriate action.

RBS

On 7/16/12, Thomas Steinmaurer <ts@...> wrote:
>> 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
>>
>>
>>
>
>
>