BUG: Cannot Run Cross-Tab Query from Catalog Manager

ID: Q120188

2.60 2.60a | 2.60a

WINDOWS    | MACINTOSH

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: KBSubcategory: FxtoolRqbe

Keywords          : kberrmsg FxtoolRqbe 
Version           : 2.60 2.60a | 2.60a
Platform          : MACINTOSH WINDOWS