Subject RE: [firebird-support] INSERT Multiple Rows same SQL Statment
Author Sasha Matijasic
>
> 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.
>

I think it's easier like this:

insert into table_ (field1, field2)
select val1_1, val2_1 from rdb$database union all
...
select val1_2, val2_2 from rdb$database;

And as far as i know, firebird supports this since ever (didn't test it though).

Sasha