Multiple Firebird Operators

Is there a way to execute multiple statements (none of which should return anything) in Firebird? How to import an SQL file and execute it.

I searched for a while and found nothing for this.

+5
source share
5 answers

Should a normal delimiter request work? How:

Update stuff; Delete stuff; Update stuff;
0
source

The execution task is exactly for this purpose. Works in IBExpert , a simple example:

execute block as
begin
  Update stuff; 
  Delete stuff; 
  Update stuff;
end

A comprehensive guide with temporary variables and loops in it: http://www.firebirdsql.org/refdocs/langrefupd15-psql-execstat.html

+5
source

IBExpert Script Executive (Menú Tools → Script Executive). , , Script Executive " " .

+2

IBExpert script Tools → Script Executive (Ctrl + F12)

+1

IBOConsole ( www.mengoni.it). SQL script ";" .

0

All Articles