Re: [DUG]: Paradox Date Format Trouble

[Tony Sinclair]

> 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