[DUG] SQL Keywords

[Alister Christie]

I removed all the SQL reserved words from our application a couple of 
years ago.  It was a bit of a mission and very tedious.  Could mostly do 
it with search and replace.  Managed to do it with all the reports as 
well - it was nice not to have to manually fix them all.

Alister Christie
Computers for People
Ph: 04 471 1849 Fax: 04 471 1266
http://www.salespartner.co.nz
PO Box 13085
Johnsonville
Wellington 



Eion McIntosh (Christchurch) wrote:
>
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>