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

Shouldn't make a difference. Where/how did you execute the EXECUTE BLOCK
statement? Do you fetch all rows in both scenarios?


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/