Re: Reserved Word Field Name Crashes SQL Builder

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

Article #945

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

#945

From: Steve Koterski
Date: Thu, 04 Jun 1998 00:00

47 lines
2314 bytes

On 3 Jun 1998 21:21:56 GMT, "Alan" <ABoba@Compuserve.com> wrote:

[...]

>> As indicated before, use of reserved words is discouraged and...
>
>Looks like I have to dig into that "Teach Yourself SQL in 21 Days" CD that
>came with VdB. Either that or get my bank to change naming conventions in
>their download file. And I don't think that's going to happen!

See the local SQL online help file, LOCALSQL.HLP, in the main BDE
directory. This help file contains a list of reserved words that cannot be
used in local SQL. Pass-through SQL to other database types can involve
different reserved words, which should be documented in the manuals for the
specific database system. But in general, you can count on the keywords in
the SQL-92 specification being reserved words in pretty much any database
system.

Here are a number of books I like and use. (Note: this is a personal
recommendation and not any form of official INPRISE endorsement of these
books over any others.)

  Understanding the New SQL, a Complete Guide
  Jim Melton & Alan R. Smith
  Morgan Kaufmann, 1993
  ISBN: 1-55860-245-3

  SQL Instant Reference
  Martin Gruber
  Sybex, 1993
  ISBN: 0-7821-1148-3

  A Guide To the SQL Standard, Third Edition
  C.J. Date & Hugh Darwen
  Addison-Wesley, 1993
  ISBN: 0-201-55822-X

  The Practical SQL Handbook, Second Edition
  Judith S. Bowman, Sandra L. Emerson, & Marcy Darnovsky
  Addison-Wesley, 1993
  ISBN: 0-201-62623-3

**************************************************************************
Steve Koterski
INPRISE Corporation, Technical Publications
http://www.inprise.com/delphi

Technical Details

Message-ID: <357fcfa5.6374227@forums.inprise.com>

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

References: <01bd8ee1$d575e0e0$c58baec7@ctx> <357cb34b.19646519@forums.inprise.com> <01bd8f36$ea151ca0$77c3afce@ctx>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b0b2a4c92d05bb82
X-Google-Attributes: gidff5a1,public
From: koterski@borland.com (Steve Koterski)
Subject: Re: Reserved Word Field Name Crashes SQL Builder
Date: 1998/06/04
Message-ID: <357fcfa5.6374227@forums.inprise.com>
X-Deja-AN: 359532163
Content-Transfer-Encoding: 7bit
References: <01bd8ee1$d575e0e0$c58baec7@ctx> <357cb34b.19646519@forums.inprise.com> <01bd8f36$ea151ca0$77c3afce@ctx>
Mime-Version: 1.0
Reply-To: koterski@borland.com
Content-Type: text/plain; charset=us-ascii
Organization: INPRISE Corporation, Technical Publications
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message