SQL Syntax Errors Encountered Dialog Box

Notifies you that the Query 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; 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 parsed. Choose OK to proceed.

Tip   If you suspect that your SQL statement contains errors, choose the Verify SQL Syntax button on the Query toolbar to check the statement.