[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