Field name is a SQL keyword

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

Article #478

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

#478

From: thall
Date: Fri, 04 Dec 1998 00:00

9 lines
878 bytes

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

Tom

Technical Details

Message-ID: <36687297.506F7EDD@deltanet.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,263bb4574f8d2dfc,start
X-Google-Attributes: gidff5a1,public
From: thall <thall@deltanet.com>
Subject: Field name is a SQL keyword
Date: 1998/12/04
Message-ID: <36687297.506F7EDD@deltanet.com>
X-Deja-AN: 418783383
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql