On March 15, 2003 03:35 pm, develop111 wrote:

> 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 ?

Usually when you start bumping into limits, it's not the limit that is too
small, it's that your trying to do something bass-ackwards:-) For example,
where are the 1500+ items coming from? Could it be a table? Maybe it should
be a table.