Re: Works in VFP6 but not in VFP 8

From: Walter Graff (WalterGraff_at_discussions.microsoft.com)
Date: 02/25/05


Date: Thu, 24 Feb 2005 17:33:04 -0800

Thanks Nigel

I didn't realize they changed the syntax from 6 to 8.

"Nigel Gomm" wrote:

> see set enginebehaviour at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/lngset.asp
>
>
> "Walter Graff" <WalterGraff@discussions.microsoft.com> wrote in message
> news:B021AACB-6697-44CB-843C-65721BD83231@microsoft.com...
> > 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.
>
>
>