--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Hello Graig,
>
> > 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 ? ).
>
> For one thing, Database Workbench does not yet like this :-)
>
> Although it supports all other Firebird 2 PSQL features, it does

not

> yet support "execute block".
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

Ah, well that will help explain my confusion as well :) OK, then i
can 'fall back' to the good ol' ISQL client for testing this then.

Of course, you know that my next question will be 'when will this
support be ready?', but I'll hold off for now, and besides, that's a
question for another forum anyway.

Thx for the help!

Greg