Reserved words - just like you can't use words like 'begin' or 'write'
as a variable name in Pascal.

Grant Black
Software Developer
SmartMove (NZ) Ltd
Phone:     +64 9 361-0219 extn 719
Fax  :     +64 9 361-0211
Email:     [EMAIL PROTECTED]

> -----Original Message-----
> From: John Christenhusz [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 10, 1998 2:30 PM
> To:   Multiple recipients of list delphi
> Subject:      TwwQuery
> 
> Hi all,
> 
> I'm using this TwwQuery, but I found out that from a table the fields
> "Date" and Time" are not declarable as such in the SQL statement. When
> I rename the table fields to "XDate" and "XTime" it all seems to work.
> See example below:
> 
> 
> SELECT msg.*
> FROM MESSAGES.DB msg
> WHERE  (msg.ErrorLevel >= :ErrorLevel)
>    AND (msg.XDate      >= :DateFrom)
>    AND (msg.XDate      <= :DateTo)
> 
> 
> Any ideas why Date and Time can't be used in the SQL ????
> 
> Thanks,
> 
> 
> John Christenhusz
> POSTEC DATA SYSTEMS Ltd.
> PO Box 302-230
> Auckland, New Zealand
> E-mail: [EMAIL PROTECTED]
> Phone: 09-415.8803
> Fax: 09-415.9042
> 
> 
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to