Hi,

I have faced a weird behaviour in Firebird 2.5.0.

When executing the following (execute is in lowercase) , the block is
returning the
expected 3 rows: [1,2,3]

execute block
returns(val INTEGER)
as
begin
val=1;SUSPEND;
val=2;SUSPEND;
val=3;SUSPEND;
end

When executing the following (execute is in uppercase), the block is
returning a single
row only: [1], SUSPEND seems to act as an exit statement.

EXECUTE block
returns(val INTEGER)
as
begin
val=1;SUSPEND;
val=2;SUSPEND;
val=3;SUSPEND;
end

Could you please help me to fix this problem ?

Many thanks

Kind regards, Laurent





[Non-text portions of this message have been removed]