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