Subject Re: [firebird-support] Inserting Rows into DB
Author Ivan Prenosil
> Is there some syntax
> to build multiple VALUES list entries and insert them with one execute
> statement I can research further?

With FB2 there is one possibility:

EXECUTE BLOCK AS
BEGIN
INSERT INTO tab(a) VALUES (10);
INSERT INTO tab(a) VALUES (20);
INSERT INTO tab(a) VALUES (30);
INSERT INTO tab(a) VALUES (40);
INSERT INTO tab(a) VALUES (50);
END

It is executed as single command so it reduces network traffic,
otoh it does not take advantage of using prepared statements.

Ivan
http://www.volny.cz/iprenosil/interbase/