Re: CREATE OR REPLACE VIEW

Article View: borland.public.interbase.sql

Article #11367

Back to borland.public.interbase.sql Previous Next

#11367

From: Martijn Tonies
Date: Mon, 25 Nov 2002 12:38

36 lines
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
>
>

Technical Details

Message-ID: <3de21947$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!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3de20d93@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 04:39:01 PST
From: "Martijn Tonies" <m.tonies@upscene_remove.com>
Newsgroups: borland.public.interbase.sql
References: <3de20d93@newsgroups.borland.com>
Subject: Re: CREATE OR REPLACE VIEW
Date: Mon, 25 Nov 2002 13:38:47 +0100
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.238.179.102
Message-ID: <3de21947$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038227783 212.238.179.102 (25 Nov 2002 04:36:23 -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!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message