Query Definitions Differ Dialog Box

See Also      Tasks

Notifies you that your query cannot be represented graphically in the Diagram and Grid panes and that you will be able to edit your query only in the SQL pane. This dialog box appears when you enter or edit an SQL statement in the SQL pane; and then switch to another pane, verify the query, or attempt to execute the query; and one of the following conditions applies:

• The SQL command is incomplete or contains one or more syntax errors.
  
  
• The SQL command is valid but is not supported in the graphical panes (for example, a Union query).
  
  
• The SQL command 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 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.

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.

Options

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 Query Designer dims the Diagram and Grid panes to indicate that they do not represent the statement in 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.

No

Choose this button to discard the changes in the SQL pane and revert to the most recent SQL statement that can be represented in the Diagram and SQL panes.