Message
From
19/12/2006 09:57:18
To
19/12/2006 09:50:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01178051
Message ID:
01178849
Views:
22
Sorry, we cannot move further until you will tell me if this SQL returns right data:
SELECT vendorID, ;
cnt(*) AS NumReceipts, ;
SUM(qtyrecv) AS QtyRecv, ;
SUM(qtyrej) AS QtyRej ;
FROM PoEntry ;
INTO CURSOR VndrPerf ;
group by 1
It doesn't mean that anything else Ok, but you claim that data result is wrong so you got to make sure firstly that this SQL really works for you.
SELECT vendorID, ;
cnt(*) AS NumReceipts, ;
SUM(qtyrecv) AS QtyRecv, ;
SUM(qtyrej) AS QtyRej ;
FROM PoEntry ;
INTO CURSOR VndrPerf ;
group by 1
It doesn't mean that anything else Ok, but you claim that data result is wrong so you got to make sure firstly that this SQL really works for you.
Edward Pikman
Independent Consultant
Independent Consultant