Subject Re: [firebird-support] problem with query length
Author Helen Borrie
At 08:43 PM 6/10/2010, you wrote:
>Hi All,
> I'm using firebird 2.1.3 and IBO query object. I'm using a query whose length is greater than 6564 characters.
>The whole query is not fitting into the Sql of the query component. I tried this by directly adding into the SQL of the query component and also by using the string variable and ansistring variable in all the cases the i'm facing the same problem.
>How to overcome this.

Make your query fit into the *engine* limit of 64KB for any statement. Note that the 64KB encompasses all white space as well as the run-time size of the data that is plugged into your parameters.

In the IBO scenario, check whether your method of building your SQL statement is being over-zealous in eating white space. If you are not using table aliases, now might be a good time to start doing so.