Subject RE: [ib-support] IN limitation to 1500 ?
Author Martijn Tonies
Well, I guess you answered your own question:

Yes, it's limited to 1500. The database engine is telling you :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

With a select that contain a IN statement, I get the following error
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.

[Non-text portions of this message have been removed]