I haven't got the original message - Is the problem that you get an empty
result back? In which case does it need a 4 digit year?
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tony Sinclair
Sent: Thursday, 1 July 1999 11:40
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Paradox Date Format Trouble
> My recollection from running the Database Explorer and doing a query in
the
> SQL window, is that literal dates need to be in quotes. Does this apply to
> your situation?
>
This is the SQL string I tested with in Database Desktop and it works fine
SELECT SH.Terminal, Sum(SH.Invoice) AS TotalSale, SH.SaleType
FROM SaleHeader.db SH
WHERE (SH.SaleType = 1) AND (SH.SaleDate BETWEEN "06/16/99" AND "06/16/99")
GROUP BY Sh.Terminal, SH.SaleType
ORDER BY SH.Terminal
but as soon as I use it in a TSQL component it doesn't seem to like it.
Making
sure dates are in mm/dd/yy format.
--
Tony Sinclair
Christchurch
New Zealand
"I like deadlines. I especially like the
sound they make as they go wizzing by."
---------------------------------------------------------------------------
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
