SQL Syntax Errors Encountered Dialog Box

Notifies you that the designer cannot parse the SQL statement 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.

This dialog box appears when you enter or edit an SQL statement in the SQL pane; and 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 on the Query toolbar.

The dialog box displays a message with the reason that the SQL statement cannot be parsed. Choose OK to proceed.

See Also

Other Resources

Designing Queries and Views