Subject Re: [firebird-support] Max length of SQL statement
Author Martijn Tonies
> 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:
> 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
My thoughts:
Database development questions? Check the forum!