Re: Sql Error

Article View: borland.public.interbase.sql

Article #442

Back to borland.public.interbase.sql Previous Next

#442

From: Adalberto Baldini
Date: Tue, 18 Mar 2008 10:36

21 lines
1409 bytes

Adalberto Baldini wrote:
I have this view :

CREATE VIEW OPE_DOC_VIEW(
     CSOC,
     NRESERC,
     ...)
AS
select coalesce( b1.CSOC, b2.csoc),
        coalesce (b1.NRESERC, b2.nreserc),
       .....

removing coalesce with
AS
select b2.csoc,
        b2.nreserc,
       .....

it works but it should also work in original version. ??

Adalberto

Technical Details

Message-ID: <47df9b17@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <47df8d5f$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,4d2d69b99c57604e
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 18 Mar 2008 11:36:06 +0100
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Sql Error
References: <47df8d5f$1@newsgroups.borland.com>
In-Reply-To: <47df8d5f$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.183.140.110
Message-ID: <47df9b17@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1205836567 80.183.140.110 (18 Mar 2008 03:36:07 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message