SQL Syntax Errors Encountered Dialog Box (Visual Database Tools)

This dialog box notifies you that the designer cannot parse the SQL statement in the SQL pane.

This dialog box appears when you enter or edit an SQL statement in the SQL pane; then 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. Click OK to proceed.