🚀 go-pugleaf

On Wed, 11 Feb 1998 12:29:10 +0100, Andrea Starz <starzand@mbox.vol.it>
wrote:

>I want to select record between two date, if i wrote:
>
>SELECT OL_AGG, COUNT(  DISTINCT COM_AGG )
>FROM "C:\APPL\ACOL\aggiorna.dbf" Aggiorna
>WHERE DATA_AGG  BETWEEN {01/12/97} AND {31/12/97}
>ORDER BY OL_AGG
>
>an error "invalid use of keyword {" occour.
>
>Where is the method to write a date value?

Try enclosing the date literals in double-quotes.

Also, mixing aggregated and non-aggregated columns in the SELECT clause
columns list without having a GROUP BY clause does not look right and may
produce incorrect or no results.

Try something like:

  SELECT OL_AGG, COUNT(DISTINCT COM_AGG)
  FROM "C:\APPL\ACOL\aggiorna.dbf"
  WHERE (DATA_AGG BETWEEN "01/12/97" AND "31/12/97")
  GROUP BY OL_AGG
  ORDER BY OL_AGG

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)