Subject | Re: [firebird-support] Firebird 2.0 and EXECUTE BLOCK |
---|---|
Author | Ivan Prenosil |
Post date | 2006-02-22T10:23:03Z |
> I am trying out the FB 2.0 beta 2, and am curious about the new EXECUTEIt works fine for me (just copy-pasted your example into ISQL).
> 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 ? ).
Can you try different build ? (I have 12306)
Ivan