|Subject||Re: [ib-support] IN limitation to 1500 ?|
|Author||Roberto de Amorim|
> With a select that contain a IN statement, I get the following errorWell, so you must minimize you IN statement result using a WHERE clause. If
> message :
> Dynamic SQL Error
> SQL error code = -901
> Implementation limit exceeded
> too many values (more than 1500) in member list to match
> In fact my IN statement contain more than 1500 values.
it already exists, then you may create a stored procedure with a "FOR
SELECT" and test it into the FOR...
or better, you may compare if the COUNT of your statement is > the 0...
SELECT * FROM TABLE1
(select count(*) from table2) > 0