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
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