[firebird-support] Execute SQL scrip (few sql statements) in one step in SP

2014-06-21 Thread majst...@yahoo.com [firebird-support]
Hello, I have an idea to transfer some client side code to Firebird SP and speed up and secure those work. My client side application procedure is collect some SQL statements from 1 to n depent of situation and made some unique SQL statement divided by ; and execute it from app. Now

Re: [firebird-support] Re: Execute SQL scrip (few sql statements) in one step in SP

2014-06-21 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
The query I've been sending you could be inside a stored procedure: create porcedure P_EXEC_SCRPT(CMDS varchar(16)) as declare variable CMD varchar(16)) begin for with recursive... select CMD from ... into :CMD do execute statement :CMD; end If you are not executing the execute