is "NAME" a reserved word in Interbase ?

Article View: borland.public.interbase.sql

Article #763

Back to borland.public.interbase.sql Previous Next

#763

From: Paul
Date: Wed, 27 Jun 2007 08:35

41 lines
1757 bytes

I did a quick check online and it does not appear as a reseved word
for IB6 abyway AFAIK. However, I often find problems when fields are
just called "name".

For example, the following procedure parses ok in IBConsole but
generates an error when executed...
//=======================================
CREATE  PROCEDURE GET_CUSTOMER
(
  ....
)
RETURNS
(
  .....
)
AS
BEGIN
FOR SELECT NAME ,ADDRESS_1,ADDRESS_2,ADDRESS_3,ADDRESS_4,ADDRESS_5
FROM CUSTOMERS WHERE UPPER(ACCOUNT_REF) =:CUSTREF INTO
:CNAME,:CADDR1,:CADDR2,:CADDR3,CADDR4,CADDR5
DO SUSPEND;
END
.. etc.

//=======================================

However, if I change it from ..

...FOR SELECT NAME ..
 To
...FOR SELECT NAME AS ANAME ..

All is ok. No errors. 

Strange ?

Thanks.

OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
CPU : AMD 3500+

Technical Details

Message-ID: <es6483trama462emaa22ajtn38q7eh1mp1@4ax.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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5365f1f67bc33110,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: Paul <nospam@sdiespammersdie.com>
Newsgroups: borland.public.interbase.sql
Subject: is "NAME" a reserved word in Interbase ?
Date: Wed, 27 Jun 2007 09:35:52 +0100
Organization: None
Message-ID: <es6483trama462emaa22ajtn38q7eh1mp1@4ax.com>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.150.143.163
X-Trace: newsgroups.borland.com 1182933351 86.150.143.163 (27 Jun 2007 01:35:51 -0700)
Lines: 41
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