Subject Re: What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5
Author Craig Cox
Thanks everyone! That provided the answer I needed.

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> >>> 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
>
> Oh, right, sure. ;-)
>
> Or even *bytes* and not characters. I haven't checked, because luckily,
> I don't even to deal with such statements.
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>