> > I thought the only downfall of selectable stored procedures was that if
> > you joined to something else it would not use any indexes. I might be
> > wrong or out of date though. With that said, however, we don't use
> > views anymore because of the lack of altering.
>
> ? why would you need 'ALTERING'
> A view is just looking at the existing tables, I just drop, and load the
> revised schema. You do document the schemas? ;)
>
> Views are a nice quick way to build a simple view of complex data
>
> --
> Lester Caine

me too...
I must be spoilt though, because I use IBExpert and when I want to alter a
view, IBExpert does it all for me. It creates a script to drop all
dependencies, then the view, then re-creates the view and re-creates all the
dependencies. It warns me of course, when my recreation does not re-create
something which is depending on it.
Alan
PS - I do keep my fingers crossed when I do it (and I do a backup before
hand). But it has never failed me yet.