🚀 go-pugleaf

Steve Koterski wrote:
> 
> 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!)

Ok , another error :

"Database Engine Error: Type mismatch in expression"

N.B.: Date are in format dd/mm/yy, is important?

Andrea