At 02:56 PM 30-07-02 +0800, you wrote:

>Dear All,
>
>I want make a VIEW where the select command like this :
>
>CREATE VIEW (LANGUAGES_ENGLISH_NAME)
>AS
>SELECT LANGUAGES_ENGLISH_NAME FROM GETTING_PUBLISH(4,'MANAGER');
>
>which GETTING_PUBLISH is a stored procedure. When i run this at IB Console ,
>always
>error :
>
>Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 3, char 43
>(
>
>why ? Is firebird does not allow reslt from sotred procedure to be a VIEW ??

A view is a set extracted from a table. A stored procedure isn't a table -
it's a piece of compiled code which, if written using a certain syntax, can
output a dataset at run-time. CREATE VIEW needs a table and all its column
definitions in order to store the view definition with *its* column
definitions.

Actually, I think of a selectable stored procedure as a kind of view
anyway; albeit a view which can't be made updatable via SQL. Even if it
were possible somehow to create a view from the output of a SSP, what would
be the point? If LANGUAGES_ENGLISH_NAME is already an output of the stored
procedure, why not just get the dataset you want with

SELECT LANGUAGES_ENGLISH_NAME FROM GETTING_PUBLISH(4,'MANAGER');

????

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________