is there any way to execute multiple statements (none of which will have to return anything) on Firebird? Like importing a SQL file and executing it.
I've been looking for a while and couldn't find anything for this.
Execute block is exactly for that purpose. Works in IBExpert too, a simple example :
execute block as
begin
Update stuff;
Delete stuff;
Update stuff;
end
Comprehensive guide, with temporary variables and cycles into it:
EXECUTE BLOCK
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With