Subject Re: [firebird-support] Firebird 2.0 and EXECUTE BLOCK
Author Ivan Prenosil
> I am trying out the FB 2.0 beta 2, and am curious about the new EXECUTE
> BLOCK feature. I can't seem to get it to work, though...
>
> My sample follows:
>
> execute block returns (ID bigint)
> as
> begin
> for select nID from MYTABLE
> into :ID do
> begin
> suspend;
> end
> end
>
> Trying this in (the latest) Database Workbench or with ISQL tells me
> that it doesn't like the :ID in the INTO statement (Dynamic SQL Error
> SQL error code = -104 Token unknown - line 5, column 8 ? ).

It works fine for me (just copy-pasted your example into ISQL).
Can you try different build ? (I have 12306)

Ivan