[DUG] SQL Keywords

Stephen Barker Steve at webdata.co.nz
Thu Jan 18 14:25:36 NZDT 2007


Hi,

You may also have to prefix with tablename as in:

Select orders."date" from orders

Regards,
Steve 

> -----Original Message-----
> From: Struan Judd [mailto:struan.judd at ecargo.co.nz] 
> 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
> 
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.432 / Virus Database: 268.16.13/632 - Release 
> Date: 16/01/2007 4:36 p.m.
>  
> 


More information about the Delphi mailing list