> Is there a maximum length for an SQL statement inherent in Firebird?
> I am working on something right now where I generate a SELECT
> statement of the form:
>
> SELECT * FROM SOME_TABLE WHERE THE_KEY IN (...)
>
> where the IN clause can conceivably contain a rather long list of
> primary keys to be retrieved.
>
> I am wondering if I am eventually going to run into some limit that
> will bite me on the butt using this approach.

The IN limit is reached before the maximum SQL size limit.

It's about 1500 items or so.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com