|Subject||Re: [firebird-support] Max length of SQL statement|
> Is there a maximum length for an SQL statement inherent in Firebird?The IN limit is reached before the maximum SQL size limit.
> 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.
It's about 1500 items or so.
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!