If want to stick with date literals and not put date parameters in your
queries, try putting in a format of "dd-mmm-yyyy" (including the quotes,
eg. "01-Dec-1997" - you can use FormatDateTime to get your dates in this
format). For some reason it doesn't seem to like dd/mm/yyyy or
mm/dd/yyyy. I've had success with this in paradox, anyway.
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
> -----Original Message-----
> From: Tony Sinclair [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 01, 1999 11:40 AM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Paradox Date Format Trouble
>
> 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
application/ms-tnef
