Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Firebird multiple statements

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.

like image 914
zz1433 Avatar asked Nov 08 '09 22:11

zz1433


1 Answers

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

like image 176
TPAKTOPA Avatar answered Sep 25 '22 11:09

TPAKTOPA