DOC: Cross-Tab Query Help Example is Incorrect

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: 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: 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.

   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
				

   _GENXTAB = C:\VFP\VFPXTAB.PRG