Article View: borland.public.interbase.sql
Article #11369Re: CREATE OR REPLACE VIEW
From: 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 > > > > > >
Technical Details
Message-ID:
<3de21f20$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3de20d93@newsgroups.borland.com> <3de21947$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,56ce78e43da39fc3 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-11-25 05:23:27 PST From: "Gon�alo Martins" <gmartins@netcabo.pt> Newsgroups: borland.public.interbase.sql References: <3de20d93@newsgroups.borland.com> <3de21947$1@newsgroups.borland.com> Subject: Re: CREATE OR REPLACE VIEW Date: Mon, 25 Nov 2002 13:01:21 -0000 Lines: 53 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.18.170.84 Message-ID: <3de21f20$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1038229280 212.18.170.84 (25 Nov 2002 05:01:20 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail