Thread View: borland.public.interbase.sql
5 messages
5 total messages
Started by Gon�alo Martins
Mon, 25 Nov 2002 11:46
CREATE OR REPLACE VIEW
Author: Gon�alo Martins
Date: Mon, 25 Nov 2002 11:46
Date: Mon, 25 Nov 2002 11:46
12 lines
1563 bytes
1563 bytes
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
Re: CREATE OR REPLACE VIEW
Author: Martijn Tonies
Date: Mon, 25 Nov 2002 12:38
Date: Mon, 25 Nov 2002 12:38
36 lines
1984 bytes
1984 bytes
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 > >
Re: CREATE OR REPLACE VIEW
Author: Gon�alo Martins
Date: Mon, 25 Nov 2002 13:01
Date: Mon, 25 Nov 2002 13:01
51 lines
2327 bytes
2327 bytes
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 > > > > > >
Re: CREATE OR REPLACE VIEW
Author: Martijn Tonies
Date: Mon, 25 Nov 2002 14:54
Date: Mon, 25 Nov 2002 14:54
78 lines
3146 bytes
3146 bytes
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 > > > > > > > > > > > >
Re: CREATE OR REPLACE VIEW
Author: Gon�alo Martins
Date: Mon, 25 Nov 2002 17:36
Date: Mon, 25 Nov 2002 17:36
99 lines
3910 bytes
3910 bytes
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 > > > > > > > > > > > > > > > > > > > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads