Query Definitions Differ 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 appears when you enter or edit an SQL statement in the SQL pane; then you 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.
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 Criteria panes, because Query and View Designer assumes that you are editing only in the SQL pane.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
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.Note
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.