SELECT Category + STR(wmretail,8,2) AS IndexMe, SUM(Shipped) AS Shipped, ;
SUM(ShippedYTD) AS ShippedYTD, SUM(Return) AS Return, ;
SUM(ReturnYTD) AS ReturnYTD, SUM(Sold) AS Sold, ;
SUM(SoldYTD) AS SoldYTD ;
FROM WalDataFile ;
GROUP BY Category + STR(wmretail,8,2) ;
INTO CURSOR PricePtSum
VFP cannot match group expressions
you can:
SELECT Category + STR(wmretail,8,2) AS IndexMe, SUM(Shipped) AS Shipped, ;
SUM(ShippedYTD) AS ShippedYTD, SUM(Return) AS Return, ;
SUM(ReturnYTD) AS ReturnYTD, SUM(Sold) AS Sold, ;
SUM(SoldYTD) AS SoldYTD ;
FROM WalDataFile ;
GROUP IndexMe ;
INTO CURSOR PricePtSum
or
SELECT Category + STR(wmretail,8,2) AS IndexMe, SUM(Shipped) AS Shipped, ;
SUM(ShippedYTD) AS ShippedYTD, SUM(Return) AS Return, ;
SUM(ReturnYTD) AS ReturnYTD, SUM(Sold) AS Sold, ;
SUM(SoldYTD) AS SoldYTD ;
FROM WalDataFile ;
GROUP BY 1 ;
INTO CURSOR PricePtSum
