On 18-1-2013 16:08, laurentricci wrote: > 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 ?
Just tested it on Firebird 2.5.2 with Flamerobin and both work exactly the same. I don't think this was broken in 2.5.0, so the problem is most likely in the way you are executing. How are you executing this? Maybe that tool has an internal parser that is case-sensitive and does something different when it reads EXECUTE vs execute. Mark -- Mark Rotteveel
