Microsoft KB Archive/135842

= DOC: SQL Statement Disagrees with Text Description =

Article ID: 135842

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q135842



SUMMARY
Page 355 in the Developer's Guide has a text description followed by code to display companies that have more than $50,000 in total orders for the year. However, the SQL statement displays companies with more than $1,000 in total orders for the year.

This documentation error has been fixed in Visual FoxPro 5.0 for Windows.



MORE INFORMATION
The SQL statement currently reads as follows:

SELECT customer.company_name, SUM(orders.freight) ; FROM tastrade!customer, tastrade!orders ; WHERE customer.customer_id = orders.customer_id ; GROUP BY customer.company_name ; HAVING SUM(orders.freight) > 1000 ; ORDER BY 2 DESC This SQL statement's HAVING clause should be changed to the following to display companies with more than $50,000 in total orders for the year and to match the text description: HAVING SUM(orders.freight) > 50000 ;

Additional query words: 3.00 docerr VFoxWin 5.00

Keywords: kbdocfix KB135842

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.