Subject | Re: View and stored procedure data |
---|---|
Author | Svein Erling Tysvær |
Post date | 2006-03-22T19:44:12Z |
Unlike some of us, neither Thomas nor Helen use to write something
incorrect on this list. This time, I haven't got a clue who is right,
but try this as a final test:
create view View_name(Field1,. Fieldn )
as select Field1, . Fieldn
from Table1
join Table2 on .
left join SPname() on .
Set
incorrect on this list. This time, I haven't got a clue who is right,
but try this as a final test:
create view View_name(Field1,. Fieldn )
as select Field1, . Fieldn
from Table1
join Table2 on .
left join SPname() on .
Set
--- In firebird-support@yahoogroups.com, "lmmolinero" wrote:
> Thomas
>
> I also think it isn't allowed to use a stored procedure in a view,
> but I trust Helen, and I tried the Pavel suggestion without success,
> so I continue to think I can't use a stored procedure in a view.
>
> > > create view View_name(Field1,. Fieldn )
> > > as select Field1, . Fieldn
> > > from Table1
> > > join Table2 on .
> > > join SPname() on .