TTable and quoted fieldnames in SQL

Article View: comp.lang.pascal.delphi.databases

Article #37

Back to comp.lang.pascal.delphi.databases Previous Next

#37

From: Frank
Date: Thu, 12 May 2005 12:24

16 lines
1308 bytes

I am using a TTable to connect to a MSSQL-table.

Sometimes Delphi generates SQL with quotes around fieldnames and
sometimes not when openeing the table.

E.g.

select ID, NAME from TABLE1
select "ID", "NAME" from "TABLE1"

I am using BDE, and as some of MSSQL-fieldnames are reserved words,
and i therefor always needs to use quotes. The reason the reserved
words are used, is that the applicaiton was ported from Sybase.


/frank

Technical Details

Message-ID: <6a4d4be4.0505120424.4cf0479c@posting.google.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: ffff5,33ed11bc76e39717,start
X-Google-Thread: 10de66,33ed11bc76e39717,start
X-Google-Attributes: gidffff5,gid10de66,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail
From: frankmule@gmail.com (Frank)
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers
Subject: TTable and quoted fieldnames in SQL
Date: 12 May 2005 05:24:30 -0700
Organization: http://groups.google.com
Lines: 16
Message-ID: <6a4d4be4.0505120424.4cf0479c@posting.google.com>
NNTP-Posting-Host: 213.161.246.244
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1115900670 23320 127.0.0.1 (12 May 2005 12:24:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 May 2005 12:24:30 +0000 (UTC)