--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>try committing the original query and then run your
>altered SP again.

step 1:
create procedure test
returns
(result integer)
as
begin
result=1;
suspend;
end

step 2:
create procedure test1
returns
(result integer)
as
begin
select result from test into :result;
suspend;
end

step 3:
(try procedure test1)

select result from test1

Result=1 (as expected)

step 4:
alter procedure test
returns
(result integer)
as
begin
result=2;
suspend;
end

step 5:

(try procedure test1)

select result from test1

Result=1 (instead of the expected value 2)

step 6:

(commit)

commit

step 7:

(try procedure test1)

select result from test1

Result=1 (instead of the expected value 2)

>if you are using a tool that performs CommitRetaining, the old

version of the SP is still "engaged"

Should I infer that this tool performs CommitRetaining ? (The tool is
the old WISQL).

Is there a way to see the expected value 2 ?

Peppe Polpo