Q155803

layout	title	permalink
page	Q155803: DOC: Cross-Tab Query Help Example is Incorrect	/kb/155/Q155803/

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

{% raw %}

Article: Q155803
Product(s): Microsoft FoxPro
Version(s): WINDOWS:3.0,3.0b
Operating System(s): 
Keyword(s): kbdocfix
Last Modified: 14-DEC-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b 
-------------------------------------------------------------------------------

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 
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b
Version           : WINDOWS:3.0,3.0b

=============================================================================

{% endraw %}