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 ...)


Regards,

Ann
www.ibphoenix.com
We have answers.