Hi Bjoern,

> for Access with a limited DB-client (MS-Access) I want to create a
> view which returns the result of a stored proc.
>
> I've build a selectable SP called TEST_S wich works.
>
> Then I tried to build a view:
>
> create view TESTVIEW
> as
> SELECT * FROM TEST_S;
>
> which doesn't work.
>
> The server says:
>
>
> Undefined name.
> Dynamic SQL Error.
> SQL error code = -204.
> Table unknown.
> TEST_S.
> At line 3, column 15.
>
>
> Well I'm a bit confused as in Firebird Reference Guide on page 127
> it says that a selectable SP can be base of a view and in Using
> firebird guide it says, it can't.
>
> What's right?

Well, apparently, you cannot :-)

> Do I realy have to use calculated fields, filled with the result of
> a stored proc to get the info into Access?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com