🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #11369

Re: CREATE OR REPLACE VIEW

#11369
From: Gon�alo Martins
Date: Mon, 25 Nov 2002 13:01
51 lines
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-mail
References: <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