Firebird multiple statements

Question

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.

Answer 1

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

Answer 2

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.

Answer 3

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

Update stuff; Delete stuff; Update stuff;

Answer 4

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.

Answer 5

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