Re: Field name is a SQL keyword

Article View: borland.public.vdbase.data.sql

Article #479

Back to borland.public.vdbase.data.sql Previous Next

#479

From: Ken Mayer [TeamB]
Date: Fri, 04 Dec 1998 00:00

19 lines
1058 bytes

thall <thall@deltanet.com> wrote:

>I have an table from a legacy system where one of the field names is
>DESC, which is short for description.  When I try to use this field in a
>select statement I receive an error, "invalid use of keyword."  Is there
>some way to get the system to view this as a field name in a sql
>statement  and not a keyword?
>
>Example:  select partno, desc, onhand from partfile

Try partfile.desc

Ken

---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Technical Details

Message-ID: <3667d823.1911457@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <36687297.506F7EDD@deltanet.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,263bb4574f8d2dfc
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Field name is a SQL keyword
Date: 1998/12/04
Message-ID: <3667d823.1911457@forums.borland.com>
X-Deja-AN: 418804413
References: <36687297.506F7EDD@deltanet.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message