Subject Re: [firebird-support] What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5
Author Hannes Streicher
Post date 2012-08-16T14:29:27Z
Guten Tag Thomas Steinmaurer,



>> I have an application that builds dynamic queries for users as they progress through a series of forms and choose items to include. The query is then fed to and FB 1.5 database.
>>
>> I have a situation where the SQL statement causes an error, even though there does not appear to be anything wrong with the data, table structures, or SQL syntax.
>>
>> For instance, a statement that runs correctly contains 1214 lines. One that crashes has 1362 lines.
>>
>> If there is a limit in FB 1.5, does FB 2.5 have the same limit?

> Yes. ~64K for both.

64k Characters :) not lines


--
Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...