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