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.

回答1:

Shouldn't the normal query-delimiter work? Like:

Update stuff; Delete stuff; Update stuff;

回答2:

Execute statement 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 : http://www.firebirdsql.org/refdocs/langrefupd15-psql-execstat.html

回答3:

You can do it from IBExpert with Script Executive (Menú Tools -> Script Executive). Be sure to connect to the DB you want to run the query's and then at the Script Executive dialog check the "Use current connection" for this to work.

回答4:

In IBExpert you can execute multiple commands in single script via Tools->Script Executive (Ctrl+F12)

回答5:

You can do this with IBOConsole (download from www.mengoni.it). The SQL window allows you to enter a complete script with the usual ";" delimiter.