Ah, yes, didn't think of that. Any idea roughly how many characters that will be?
RBS On Mon, Jul 16, 2012 at 2:37 PM, Thomas Steinmaurer <t...@iblogmanager.com>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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/