> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Tony Sinclair
> Sent: Thursday, 1 July 1999 09:56
> To: Multiple recipients of list delphi
> Subject: [DUG]: Paradox Date Format Trouble
>
>
> Hi all,
>
> I am currently having trouble with a simple SQL script that a TSQL just
> doesn't want to accept. I have followed the date format in the
> localsql.hlp file but I keep getting an invalid format message.
>
> SQL.Add('SELECT SH.Terminal, Sum(SH.Invoice) AS TotalSale,
> SH.SaleType');
> SQL.Add('FROM SaleHeader.db SH');
> SQL.Add('WHERE (SH.SaleType = ' + IntToStr(intCount) + ') AND
> (SH.SaleDate BETWEEN "' + convertDateToUS(ReportsForm.FromDate.DateTime)
snip
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?
============================================
Patrick Dunford, Christchurch, NZ
http://patrick.dunford.com/
http://www.trainweb.org/enzedrail/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
