Reserved Word Field Name Crashes SQL Builder

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

Article #1030

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

#1030

From: Alan
Date: Wed, 03 Jun 1998 00:00

20 lines
1161 bytes

My bank downloads my account data to a Microsoft Access v2.0 database. One
of the fields is named Desc. As it turns out, "Desc" is a reserved word.
(gimmie a break, I'm a SQL novice)

If I use the Visual SQL tool, any attempt to run or close a query that uses
the "Desc" field crashes VdB.

If I use the SQL editor and enter the field name as tablename."Desc" the
queries run fine. If I subsequently open the Visual SQL tool the query gets
hosed again. I'm no where near fluent enoungh to use the SQL editor to
create my queries.

Does anyone know how to correct this problem so the reserved field name my
be selected from within the Visual SQL tool?

Does the point release that Borland charges $20 s&h correct the problem?

Thanks,
-AB

Technical Details

Message-ID: <01bd8ee1$d575e0e0$c58baec7@ctx>

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,b0b2a4c92d05bb82,start
X-Google-Attributes: gidff5a1,public
From: "Alan" <ABoba@Compuserve.com>
Subject: Reserved Word Field Name Crashes SQL Builder
Date: 1998/06/03
Message-ID: <01bd8ee1$d575e0e0$c58baec7@ctx>
X-Deja-AN: 359105779
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql