Thank you :)

I thought I remembered this.
And I have hit the 64K limit :S

Well - for now the problem has been solved.

Micahel

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> Hello Michael,
>
> > I just need a confirmation that the size of the text written to a stored procedure is limited to 65K.
>
> It's bound to the limit of ~64K for the maximum SQL statement length in
> case of your CREATE PROCEDURE statement and there is another limit on
> the maximum length of compiled BLR code, which is AFAIK ~ 48K.
>
> HTH.
>
>
> --
> With regards,
> Thomas Steinmaurer
>
> * Upscene Productions - Database Tools for Developers
> http://www.upscene.com/
>
> * My Blog
> http://blog.upscene.com/thomas/index.php
>
> * Firebird Foundation Committee Member
> http://www.firebirdsql.org/en/firebird-foundation/
>