[DUG] SQL Keywords

[Traci P Sumpter]

Sometimes Quotes work..  select "DATE" as BadlyNamedDataField  FROM 

  _____  

From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of Eion McIntosh (Christchurch)
Sent: Thursday, 18 January 2007 12:59 p.m.
To: delphi at ns3.123.co.nz
Subject: [DUG] SQL Keywords



Hi 

We have on app using Dbase tables, created sometime ago, which we need to do
a new query over one of the tables. I'm using the TQuery compenent but have
struck a snag in that one of the fields we want to query is called DATE and
the component does not like DATE because it classed as a keyword. 

Is there anyway to change to query so we can query over the DATE field
without having to rename it throughout the whol application?

I know in SQL itself you can put squarebrackets around the fieldname,
[DATE], to overcome this issue but the TQuery component doesn't like that
either.

Regards 
Eion McIntosh 
PPCS Ltd 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20070118/64c919b2/attachment.html