Hi,

>Unfortunatelly it did not work in firebird. Do we have a way to insert
>multiple rows in a single
>statment in firebird?

You have to use multiple insert statments. You may, if desited, use EXECUTE
BLOCK to 'goup' those statements.

>I want to reduce time by inserting everything i need in a single statment.

I can see where using a single statement will reduce 'time' in any way.

> I wanna insert several currency quotes in tbcurrencyquotes in the
> following format:
>USD EUR 2008 0.93
>BRL AUD 2007 x.xxx

something like

execute block as (
insert on _table_ (field1,field2,field3,field4) values ('USD', 'EUR',
2008,0.93);
insert on _table_ (field1,field2,field3,field4) values ('BLR', 'AUD',
2007,x.xx);
...
)^

(this is not the correct syntax, look at the release notes)

Note that "old" FB versions do not suport execute block.


Regards,
Anderson Farias