>> 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.

EXECUTE BLOCK may be prepared once and re-executed many times
as well as all other statements.

Regards,
Vlad