Re: Works in VFP6 but not in VFP 8
From: Nigel Gomm (nigel_at_blahblahblahnigelgomm.ca)
Date: 02/25/05
- Next message: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Previous message: Walter Graff: "Works in VFP6 but not in VFP 8"
- In reply to: Walter Graff: "Works in VFP6 but not in VFP 8"
- Next in thread: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Reply: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 19:29:32 -0500
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.
- Next message: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Previous message: Walter Graff: "Works in VFP6 but not in VFP 8"
- In reply to: Walter Graff: "Works in VFP6 but not in VFP 8"
- Next in thread: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Reply: Walter Graff: "Re: Works in VFP6 but not in VFP 8"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
