--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

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

DOH! Worked fine for me too now... very strange. Not sure why it
didnt work the first time.

I guess a silly blunder is good news... or at least an 'easy' fix.

Thx for the help!

Greg