Carl Reynolds wrote:
> 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/
>
Thanks Carl,
That worked sweet as! I had run my orginal query in both the database
desktop and SQL Explorer and that worked but it seems running from delphi, it
prefers the dd-mmm-yyyy format :)
Tony
--
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
