🚀 go-pugleaf

Ok, I'm dropping all the procedures and then drop the view and reconstruct
all.
I want to do this in one transaction but I get this error:
I drop all the procedures that use the view and then the view. When I do
this, it gives an error"View MYVIEW is in use". If I do a commit before I do
the drop of the view, then the drop of the view works...
Any tips on this? I would like to do all this in one transaction so the DB
doesn't stay in an incorrect state if an error occurs.
Thanks

Gon�alo

"Martijn Tonies" <m.tonies@upscene_remove.com> wrote in message
news:3de238fb@newsgroups.borland.com...
> 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>