[DUG] SQL Keywords

[Eion McIntosh (Christchurch)]

Yes I've tried quotes and "DATE" as FileDate and both have been rejected.

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz
[mailto:delphi-bounces at ns3.123.co.nz]On Behalf Of Struan Judd
Sent: Thursday, 18 January 2007 1:33 p.m.
To: 'NZ Borland Developers Group - Delphi List'
Subject: RE: [DUG] SQL Keywords


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 


_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20070118/69792d79/attachment.html