BUG: Cannot Run Cross-Tab Query from Catalog Manager

 Last reviewed: April 30, 1996
Article ID: Q120188
The information in this article applies to:
  • Microsoft FoxPro for Windows, versions 2.6, 2.6a
  • Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

If you run a cross-tab query from Catalog Manager by choosing the Modify button in the Catalog window and then choosing the Do Query button in the RQBE tool, an error message will appear. In FoxPro 2.6 for Windows, the error message will be: 

         Line No: 958
       Program: BAILOUT
   Error: alias _QSL0ZG1JT not found.
    Source: SET FIELDS to &mfieldsto
This message is followed by the SET FIELDS program line in GENXTAB being highlighted with the following message box displayed: 

   Cancel, Suspend, Ignore
After you choose Cancel, Suspend, or Ignore and close the program window, FoxPro returns to the RQBE window. After you close the RQBE window, FoxPro returns to the Catalog Manager window, and the Command window is visible.

In FoxPro 2.6a for Windows and Macintosh, the error message box is displayed briefly and disappears too quickly to read the message. The GENXTAB.PRG file will be displayed with the line IF _WIN highlighted and the following error message: 

   variable '_WIN' not found
In FoxPro 2.6a for Windows, the BAILOUT message will appear when the GENXTAB.PRG file is closed. In FoxPro 2.6a for Macintosh, a blank message box will appear instead of the BAILOUT message.

After these error messages, the Catalog Manager no longer functions. Selecting most menu items will result in an error message. However, the Command window is visible and can be selected with the mouse. If you type the command "SET SYSMENU TO DEFAULT" (without the quotation marks) in the Command window, the Command window menu items will appear; these items will function correctly. If the query is run again outside the Catalog Manager environment, the same error will occur. If FoxPro is closed and reopened, the query will run as expected.

WORKAROUND

To avoid this problem, either run the query from the Command window or choose Query from the Run menu when you are in Command window mode.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

  1. Create a cross-tab query. Using the CUSTOMER database, select ONO, STATE, and YTDPURCH in the RQBE Select Fields dialog box.

  2. Select the Cross Tabulate check box in the RQBE Select Fields dialog box.

  3. Do the query. A cross-tabulation of ONO and STATE appears.

  4. From the File menu, choose Catalog Manager. When prompted, save the query you just created.

  5. Select the Query tab and choose the Add button to add the cross-tab query you just created.

  6. Choose the Modify button to open the query in the RQBE window.

  7. In the RQBE window, choose the Do Query button. The error message should now occur.

Additional reference words: FoxMac FoxWin buglist2.60 buglist2.60a 2.60
2.60a catman crosstab crosstabulation relational query by example
KBCategory: kbother kberrmsg kbbuglist
KBSubcategory: FxtoolRqbe

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.