they need to surrounded by quotes to be recognized as field names
Maurice Butler Like Magic Ltd 025 273 9248
-----Original Message-----
From: Grant Black <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Thursday, 10 December 1998 15:48
Subject: [DUG]: RE: TwwQuery
>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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
