maybe inside PROC does't have suspend..

On Sat, Dec 11, 2010 at 11:56 AM, Michael Ludwig <milu71@...> wrote:

>
>
> Sławek Cabaj schrieb am 11.12.2010 um 03:34 (-0800):
> > Can anybody tell me what's wrong with this procedure ?
>
> There is nothing wrong with it.
>
> The SKIP 1 inside the procedure can be tricky, though.
>
> > When I try to use it in select statement, for instance
> >
> > [...]
> > WHERE SOME_FIELD IN (SELECT FIELD_1 FROM PROC)
> >
> > get an error: Procedure PROC is not selectable. It does not contain
> > SUSPEND statement.
>
> This works for me:
>
> select * from ttt where a in (SELECT FIELD_1 FROM PROC);
>
> Show us your real DDL and DML situation.
>
> > (Firebird 2.1.3)
>
> Firebird 2.5.0 here. It also works in 2.1.3.
>
> --
> Michael Ludwig
>
>



--
Ricardo...


[Non-text portions of this message have been removed]