Subject Re: [ib-support] IN limitation to 1500 ?
Author Ann W. Harrison
At 10:13 AM 12/27/2001 +0000, tempo93fr wrote:

>Implementation limit exceeded
>too many values (more than 1500) in member list to match
>In fact my IN statement contain more than 1500 values.

1500 static values? Gracious. Have you considered using
a database? The quick workaround is to break the list of
values into two IN clauses, like this

where <whatever> in (1 ... 1499)
or <whatever> in (1500 ...)


We have answers.