Nando Dessena wrote:

> Hello,
>
> m> How to insert multiple values with a single insert statement?
>
> You can't, but you can put multiple insert statement into a single EXECUTE
> BLOCK statement. EXECUTE BLOCK may or may not be available depending
> on your version of Firebird.
>

Multiple values are of much less interest if you prepare your queries.
The advantage of multiple values per insert is primarily that the
database doesn't have to parse, compile, and optimize the query for
each set of values. Prepared statements do that too. EXECUTE BLOCK
doesn't.


Good luck,


Ann