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