Re: Problems With Field Named "DATE"!!!!!

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

Article #935

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

#935

From: Paul Franks
Date: Wed, 08 Jul 1998 00:00

25 lines
1151 bytes

In article <MPG.100c042918710b6898af33@forums.borland.com>, 
Romain@Do.not.reply.via.e-mail says...
> select * from dates d where d.'date' > '01/01/97'
> 
> 

To stay strictly within SQL syntax I think this should use the double-
quote character as a delimiter around the keyword,

   select * from dates d where d."date" > '01/01/97'

Additional info - selecting specific fields may be flaky where a keyword 
is also a fieldname.  This seems to work OK in BDE2.52,

   select d."date" from tablename d 

but this is likely to fail,

   select "date" from tablename 

I'm not sure if 32-bit BDE has the same limitation.


-- 
Paul Franks (TeamB)

Technical Details

Message-ID: <MPG.100cb988340d53249897f3@forums.inprise.com>

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

References: <35A1E55E.6FD67A36@lightspeed.net> <MPG.100c042918710b6898af33@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ab0a17351dc2485b
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Paul Franks)
Subject: Re: Problems With Field Named "DATE"!!!!!
Date: 1998/07/08
Message-ID: <MPG.100cb988340d53249897f3@forums.inprise.com>
X-Deja-AN: 369395150
References: <35A1E55E.6FD67A36@lightspeed.net> <MPG.100c042918710b6898af33@forums.borland.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message