Views

Article View: borland.public.interbase.sql

Article #892

Back to borland.public.interbase.sql Previous Next

#892

From: Brian Ellul
Date: Thu, 21 Jun 2007 10:08

11 lines
1257 bytes

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)

2) You can't have 'identical called' field name selected from 2 different 
tables (attempt to store duplicate value(visibile to active transactions) in 
unique index RDB$INDEX_15)

Regards
Brian

Technical Details

Message-ID: <467a4d5d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,45068512d9ae4593,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Brian Ellul" <brianellul@ecenglish.nospan.com>
Newsgroups: borland.public.interbase.sql
Subject: Views
Date: Thu, 21 Jun 2007 12:08:48 +0200
Lines: 13
Organization: European |Centre
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.165.165.162
Message-ID: <467a4d5d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182420317 213.165.165.162 (21 Jun 2007 03:05:17 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail