Subject | Re: [firebird-support] Multiple dynamic sql statements supported? |
---|---|
Author | Milan Babuskov |
Post date | 2011-01-17T18:36:30Z |
Matthew Adams wrote:
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
==================================
> Already did that, and the length didn't look very familiar, so I'll eitherBeside limit of size of SQL statement there's also the limit of compiled
> 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.
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
==================================