That's all right already. I've got a script in which first there was an empty
procedure declaration, then a view using this proc and afterwards full
procedure body.

That triggered the error :)





________________________________
From: Michael Ludwig <milu71@...>
To: firebird-support <firebird-support@yahoogroups.com>
Sent: Sat, December 11, 2010 5:26:26 PM
Subject: Re: [firebird-support] Procedure x is not selectable. It does not
contain SUSPEND statement


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






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