Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding quantity in free table
Message
From
19/12/2006 09:57:18
 
 
To
19/12/2006 09:50:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01178051
Message ID:
01178849
Views:
19
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.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform