| Subject | IN clause, limitation to 1550 items |
|---|---|
| Author | develop111 |
| Post date | 2003-03-15T20:35:19Z |
I'm currently using IB 6 OpenSoucre version with my Delphi programs.
I'm planning to migrate to Firebird in a near future. A limitation
with IB 6 is that I cannot have more than 1500 items within the "IN"
clause in a query.
Example: SELECT * FROM PRODUCTS WHERE PRODUCTID IN ('PRODUCT1', '
PRODUCT2, ...)
Is this limitation is the same with Firebird ?
Many thanks
I'm planning to migrate to Firebird in a near future. A limitation
with IB 6 is that I cannot have more than 1500 items within the "IN"
clause in a query.
Example: SELECT * FROM PRODUCTS WHERE PRODUCTID IN ('PRODUCT1', '
PRODUCT2, ...)
Is this limitation is the same with Firebird ?
Many thanks