Microsoft KB Archive/142393

= PRB: Cannot Create a Quick Report/Wizard Report from a Cursor =

Article ID: 142393

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 Q142393



SYMPTOMS
Cursors based on tables that are part of a database and cursors based on free tables whose select statements include "where" clauses cannot be used to create a Quick Report or a Wizard-generated Report based on that cursor.



STATUS
This behavior is by design. Microsoft FoxPro version 2.6 allowed you to create a Quick Report or a Wizard-generated Report based on a cursor. In Microsoft Visual FoxPro this functionality is still available if the table from which the cursor was created is not part of a database.



Steps to Demonstrate Behavior
The following procedure demonstrates that under certain conditions, a cursor cannot be used to create a Quick Report or a Wizard-generated Report in Visual FoxPro.

 Open or switch to Microsoft Visual FoxPro.  Open a free table (one that is not part of a database), and type the following command in the Command window -- where  is the name of the free table: SELECT * FROM  INTO CURSOR MyCursor  On the Tools Menu, click Wizards - Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK. Note that the cursor MYCURSOR is listed in the Databases/Tables list box and is therefore available for the creation of the report. Click Cancel, and then close the table and the cursor.  Open a table that is part of a database, and type the following command in the Command window -- where <TableName> is the name of the table you just opened: SELECT * FROM <TableName> INTO CURSOR MyCursor </li> On the Tools Menu, click Wizards - Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK.</li> Note that the cursor MyCursor is not listed in the Databases/Tables list box and is therefore not available for the creation of the report. Click Cancel, and then close the table and the cursor.</li>  Open a free table and type in the following command in the Command window: SELECT * FROM <TableName> INTO CURSOR MyCursor where ; fieldname="some variable" </li> On the Tools menu, click Wizards-Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK.</li> Note that the cursor MyCursor is not listed in the Databases/Tables list box and is therefore not available for the creation of the report. Click Cancel, and then close the table and the cursor.</li></ol>

Additional query words: VFoxWin

Keywords: KB142393

-

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

© Microsoft Corporation. All rights reserved.