Already did that, and the length didn't look very familiar, so I'll either
have to (1) take it as given, (2) start digging for the limit, or (3)
request that the max buffer size be increased. I'll probably do all three.
:)

-matthew

On Mon, Jan 17, 2011 at 11:02 AM, Paul Vinkenoog <paul@...> wrote:

>
>
> Hi Matthew,
>
>
> > The exact FbException message that I get from the .NET provider after
> > removing the "set term ^ ;" and ending "^" is:
> >
> > Dynamic SQL Error
> > SQL error code = -104
> > Unexpected end of command - line 144, column 168
> >
> > Interestingly, I have way more than 144 lines in my command; I have 16113
> > lines, which equates to 16111 insert commands after you account for the
> two
> > lines "execute block as begin" and "end". Column 168 of line 144 is smack
> > dab in the middle of a datetime string.
>
> OTTOMH, the maximum size of a query string is 32K or 64K characters (or
> maybe
> bytes). I guess that's what causes the error (you guessed it yourself too).
>
> If you copy-paste the query from the start until the breaking point into
> a more or less intelligent text editor and ask for the text length (or
> save it to a file and check the file length) you'll know what the limit
> is...
> ;-)
>
> Cheers,
> Paul Vinkenoog
>
>



--
mailto:matthew@...
skype:matthewadams12
yahoo:matthewadams
aol:matthewadams12
google-talk:matthewadams12@...<google-talk%3Amatthewadams12@...>
msn:matthew@... <msn%3Amatthew@...>
http://matthewadams.me
http://www.linkedin.com/in/matthewadams


[Non-text portions of this message have been removed]