Subject Re: [firebird-support] Multiple dynamic sql statements supported?
Author Milan Babuskov
Matthew Adams wrote:
> 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.

Beside limit of size of SQL statement there's also the limit of compiled
SQL statement in BLR form. In cases like this I usually group about 100
inserts in single EXECUTE BLOCK and then run those in batches.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================