Hello,
I have a problem with stored procedure:

CREATE PROCEDURE X
RETURNS (
F_1 VARCHAR(200),
F_2 INTEGER)
AS
BEGIN
FOR
SELECT SKIP 1 Field,COUNT(Field) FROM TABLE
GROUP BY Field
ORDER BY 2 DESC
INTO :F_1,:F_2
DO
BEGIN
SUSPEND;
END
END

when I try to use it inside a view with WHERE clause (in script)

'WHERE some_field in (select F_1 from X)

get an error message

*********
Invalid token.
invalid request BLR at offset 17.
Procedure X is not selectable (it does not contain a SUSPEND statement).

What's wrong with it ?
(Firebird 2.1.3)

Sławek





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