Re: Views

Article View: borland.public.interbase.sql

Article #745

Back to borland.public.interbase.sql Previous Next

#745

From: Wayne Niddery [TeamB]
Date: Thu, 21 Jun 2007 18:48

22 lines
1650 bytes

Brian Ellul wrote:
> I would like to confirm....
>
> 1) You can't use field alliases when selecting field names. (Invalid
> command. must specify column name for view select expression)

Sure you can, the alias just has to match the declared name:

CREATE VIEW "FOO" (
  "MEMBERID",
  "SURNAME",
  "FIRSTNAME"
) AS
 select "MEMBER"."OID" as "MEMBERID",
  "MEMBER"."SURNAME", "MEMBER"."FIRSTNAME"
 from "MEMBER";

And this of course means you can handle same named columns in joined tables.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
SpaceShipOne; GovernmentZero

Technical Details

Message-ID: <467ac816$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <467a4d5d@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,45068512d9ae4593
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <467a4d5d@newsgroups.borland.com>
Subject: Re: Views
Date: Thu, 21 Jun 2007 14:48:54 -0400
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <467ac816$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182451734 69.17.170.228 (21 Jun 2007 11:48:54 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1480

Reply to Parent Message