Why don't you add some debug code to your application to confirm that the
.SQL strings you're passing are exactly what you think they are.
Also, does the test you ran inside the Database Desktop also run from within
the Database Explorer (which would make you use an alias)?
Cheers,
Kerry S
----- Original Message -----
From: Tony Sinclair <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 1 July 1999 11:40
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
