Works in VFP6 but not in VFP 8
From: Walter Graff (WalterGraff_at_discussions.microsoft.com)
Date: 02/24/05
- Next message: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Previous message: Luis I. Gomez: "How can I push a VFP Table to a SQL Server."
- Next in thread: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Reply: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 15:29:04 -0800
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: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Previous message: Luis I. Gomez: "How can I push a VFP Table to a SQL Server."
- Next in thread: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Reply: Nigel Gomm: "Re: Works in VFP6 but not in VFP 8"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
