Hi,

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?

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


I'm using firebird 1.5 (on Linux) and Easysoft ODBC driver with MS
Access XP.


Björn

--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de