Query Definitions Differ Dialog Box (Visual Database Tools)

This dialog box notifies you that your query cannot be represented graphically in the Diagram and Criteria panes, and that you can edit your query only in the SQL pane.

This dialog box may appear when you enter or edit an SQL statement in the SQL pane; you then move to another pane, verify the query, or attempt to execute the query; and one of the following conditions applies:

  • The SQL statement is incomplete or contains one or more syntax errors.
  • The SQL statement is valid but is not supported in the graphical panes (for example, a Union query).
  • The SQL statement is valid but contains syntax specific to the data connection you are using.
You can check whether a statement is valid using the Verify SQL Statement button on the Query toolbar.

The dialog box displays a message with the reason that the SQL statement cannot be represented, and then asks how you want to proceed.

The Query Definitions Differ dialog box does not appear if you have hidden the Diagram and Criteria panes.

Ignore Button

Choose this button to specify that you want to accept the SQL statement, either to edit it further or to execute it. If you accept the statement, the Diagram and Criteria panes appear dimmed to indicate that they do not represent the statement in the SQL pane.

Undo Button

Choose this button to discard your changes to the SQL pane.

If the statement is correct but not supported graphically by the Query and View Designer, you can execute it even though it cannot be represented in the Diagram and Criteria panes. For example, if you enter a Union query, the statement can be executed but not represented in the other panes.

Community Additions