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.
Should a normal delimiter request work? How:
Update stuff; Delete stuff; Update stuff;
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
IBExpert Script Executive (Menú Tools → Script Executive). , , Script Executive " " .
IBExpert script Tools → Script Executive (Ctrl + F12)
IBOConsole ( www.mengoni.it). SQL script ";" .