--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:
Helen,
after some search in NGs done by google on "selectable stored
procedure interbase", I could write the following code, that works ok
for my needs
create procedure test2
RETURNS
(COD VARCHAR(13), DES VARCHAR(40), GIAC NUMERIC(15,5) )
AS
begin
for select cod_art,des_art from art into cod, des
do
begin
execute procedure q_e(cod,'01','2002-10-15' ) returning_values
giac;
if (giac>0) then
suspend;
end
end
This is (more or less) what you meant, isn't it ?
You showed me a new world of possibilities: I had completely
overlooked the power of selectable SPs.