ients of list delphi
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
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-" (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
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]:
s,
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
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> Behalf Of Myles Penlington
> Sent: Thursday, 1 July 1999 12:03
> To: '[EMAIL PROTECTED]'
> Subject: RE: [DUG]: Paradox Date Format Trouble
>
> Dates again ...
&g
I typically use "FormatDateTime('mm/dd/', MyTDate)" which seems to work
OK
Max
-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]:
Multiple recipients of list delphi
Subject: RE: [DUG]: Paradox Date Format Trouble
> -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
>
> 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 TotalSa
> -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 curre
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
10 matches
Mail list logo
