| Subject | RE: [ib-support] IN limitation to 1500 ? |
|---|---|
| Author | Martijn Tonies |
| Post date | 2001-12-27T10:38:32Z |
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
http://www.interbaseworkbench.com
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]
Yes, it's limited to 1500. The database engine is telling you :)
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
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]