[DUG] SQL Keywords

[Struan Judd]

Eion,

The other SQL standard for quoting keywords when using them as names is the
double quote (").

Have you tried that?

TTFN, Struan

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



Struan Judd                                
Mailto:struan.judd at ecargo.co.nz Developer                              
Phone:   +64 (9) 368 9368 eCargo                                     
Fax:     +64 (9) 368 9369 Visibility - Communication - Measurement   
Mobile:  +64 (21) 685 335 Private & Confidential                     
http://www.ecargo.co.nz