🚀 go-pugleaf

On Fri, 04 Dec 1998 15:39:03 -0800, 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

To reference that column in an SQL statement, you would need to do two
things to accommodate the local SQL language parser. First, enclose the
column name in quotation marks. Second, prefix that with the table's name
or a table correlation name. Any of the three statements below would be
acceptable.

  SELECT PartFile.PartNo, PartFile."Desc", PartFile.OnHand
  FROM PartFile

  SELECT "PartFile.dbf".PartNo, "PartFile.dbf"."Desc",
    "PartFile.dbf".OnHand
  FROM "PartFile.dbf"

  SELECT P.PartNo, P."Desc", P.OnHand
  FROM PartFile P

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham