Show All

Query Definitions Differ Dialog Box

Notifies you that your query cannot be represented graphically in the Diagram and Grid panes and that you can edit your query only in the SQL pane. This dialog box appears when you enter or edit an SQL statement in the SQL pane; then you either switch 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.

  Tip

  You can check whether a statement is valid using the Verify SQL Syntax button.

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

Note   The Query Definitions Differ dialog box does not appear if you have hidden the Diagram and Grid panes, because the Query Designer assumes that you are editing only in the SQL pane.

Yes

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 Grid panes appear dimmed to indicate that they do not represent the statement in the SQL pane.

No

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

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