Re: Works in VFP6 but not in VFP 8
From: Walter Graff (WalterGraff_at_discussions.microsoft.com)
Date: Thu, 24 Feb 2005 17:33:04 -0800
I didn't realize they changed the syntax from 6 to 8.
"Nigel Gomm" wrote:
> see set enginebehaviour at
> "Walter Graff" <WalterGraff@discussions.microsoft.com> wrote in message
> > The following sql statement works fine in foxpro 2.0 for DOS and VFP 6 but
> > when executed in vfp 8 we get an error that group by clause is missing or
> > invalid.
> > Sele artrans.customer As acct,customer.Name,customer.city,
> > artrans.Product,
> > artrans.location, ;sum(artrans.qty) As tqty, ;
> > sum(artrans.qty*artrans.unitprice) As Total From artrans,customer ;
> > where artrans.customer = customer.custno And ;
> > (artrans.Date >= bdate And artrans.Date <= edate) And;
> > artrans.location = mware ;
> > group By artrans.customer,artrans.Product ;
> > Order By customer.Name Into Cursor ytd
> > Any ideas would be appreciated.