🚀 go-pugleaf

Eh, no - there isn't a simple DDL script to be created...

The alternative way would be to alter your procedures to have
an empty body of BEGIN EXIT; END (and thus removing all
dependencies), altering your view and altering the procedures
again with the full bodies.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Ok, but I supose there isn't a way of doing that with code...
> I must do an update on a client, and I can't go there myself and run the
> app.
> Thanks
>
> Gon�alo Martins
>
>
> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote in message
> news:3de21947$1@newsgroups.borland.com...
> > http://www.devrace.com/press/ibalterview.php
> >
> >
> > --
> >
> > With regards,
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase
> > http://www.upscene.com
> >
> > Firebird Workbench - the developer tool for Firebird
> > http://www.upscene.com
> >
> > Upscene Productions
> > http://www.upscene.com
> >
> > "This is an object-oriented system.
> > If we change anything, the users object."
> >
> > "Gon�alo Martins" <gmartins .pt> wrote in message
> > news:3de20d93@newsgroups.borland.com...
> > > Hello.
> > > I have this problem. I have a view that I need to change (add an extra
> > > condition in the end 'and amostra.estatistica=''T''). I can't drop the
> view
> > > since I have a lot of procedures querying the view and I get an error
> when
> > > trying to do it. Someone told me to try the 'Create or replace view' but
> I
> > > get an error also (in the or, so I guess this is not supported in
> > > Interbase).
> > > So, do you have any ideias how I can make this change without having to
> > > drop/create all the procedures?
> > > Thanks
> > >
> > > Gon�alo Martin
> > >
> > >
> >
> >
>
>