Subject Creating invalid procedures and views... Just an idea

although the subject may sound weird, it makes sense to me... Let me

Sometimes, you want to create a procedure, save it (to the db) and
work on
it later - change a few other things in the db for example. Of
course, an
invalid stored procedure cannot be used. There would be a
flag 'invalid' set
and an exception would be raised when trying to use it.

In addition to the above idea, if you have a few dependent
procedures/views/triggers, they could be marked invalid when the
interface (parameters) change.

For views, pretty much the same. I have a db with a few views,
dependent on
one another. When I want to modify a view, I have to drop it. When
there are
dependent views, I cannot drop it - but there's no ALTER VIEW... In
case, a view would be marked 'invalid' and would fail when trying to
execute - but at least it lets me alter the original view. From
there, I can
go and change the dependant views accordingly...

Any comments?


Martijn Tonies
InterBase Workbench - the developer tool for InterBase

Upscene Productions - Delphi components and InterBase tools