[DUG] SQL Keywords

Thu Jan 18 12:58:43 NZDT 2007

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/3ba0ec76/attachment.html