Microsoft KB Archive/155803

= DOC: Cross-Tab Query Help Example is Incorrect =

Article ID: 155803

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



This article was previously published under Q155803



SUMMARY
The example in the Visual FoxPro Help file, versions 3.0 and 3.0b, under "Creating Cross-Tab Queries" is incorrect. If you cut and paste this code into a program and then run it, the following error message appears:

Command contains unrecognized phrase/keyword

This is caused by a missing comma just after the right bracket (]) on the first line.

Once you make this correction and run the program, a second error message appears:

Variable "MYCURSOR" is not found

You can correct this problem by declaring MyCursor as a PUBLIC variable.

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



MORE INFORMATION
Following is the example code as it should appear: PUBLIC MyCursor SELECT Orders.to_city, YEAR[orders.order_date], ; SUM(Orders.order_amt) ; FROM TestData!Orders ; GROUP BY Orders.to_city, 2 ; ORDER BY Orders.to_city, 2 ; INTO CURSOR MyCursor DO (_GENXTAB) WITH MyCursor BROWSE NOMODIFY When running version 3.0b of Visual FoxPro, the following error message might also appear:

File does not exist

To correct this, place the following command as the first line in your Config.fpw file: _GENXTAB = C:\VFP\VFPXTAB.PRG

Additional query words: kbstream docerr vfoxwin 5.00

Keywords: kbdocfix KB155803

-

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

© Microsoft Corporation. All rights reserved.