BUG: "If\else\endif Mismatch" for Query Built w/ Query Wizard

• Microsoft FoxPro for Windows, versions 2.6, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.6, 2.6a
• Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

When you are using the Catalog Manager, you can create queries with the Query Wizard. Queries that are created with the SQL Query Wizard (these are read-only queries) will run only when the SQL Query Wizard option is chosen. If the queries are run with the Updatable Query Wizard option, one of the following error messages will appear when the Do Query button is chosen:

• FoxPro for Windows and FoxPro for Macintosh:

        Error 1211 (If\else\endif Mismatch.) occurred in CONTROL
        Catalog Manager will restart.
  

  -or-

• FoxPro for MS-DOS:

        If\else\endif mismatch.
  

CAUSE

There is an IF statement before the SQL statement that will not run except in the SQL Query Wizard.

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

The Query Wizard has two options to choose from when building queries: SQL Query Wizard and Updatable Query Wizard. The SQL Query Wizard option builds queries that are read-only and normally used in a report or a Browse window. The Updatable Query Wizard option creates a query that can be based on relations and is normally used to create screens or to edit the query directly.

If the Updatable Query Wizard query option is chosen, the query can be edited with the Relational Query By Example (RQBE) tool. If the SQL Query Wizard option is used to build a query, the RQBE tool can open the query, but when the Do Query button is chosen, the error message mentioned above occurs. This error also occurs if the query is edited with the RQBE tool from the Command window.

Steps to Reproduce Problem

1. In Catalog Manager, select the Query tab.

2. Choose the New button on the right side of Catalog Manager.

3. Choose the Query Wizard button, and then select SQL Query Wizard.

4. Fill out the six steps, finish the query, and name it.

5. Return to Catalog Manager and make sure the Query tab is selected.

6. Select (highlight) the newly built query and choose the Modify button on the right side of Catalog Manager.

7. Choose the Query Tool button, and then choose the Do Query button in the RQBE tool. The above mentioned error will occur.