Correcting unrecognized syntax in SQL statements in the SQL builder

The SQL builder supports saving and loading code that contains unrecognized syntax. When the parser encounters unrecognized syntax, parts of the SQL builder become unavailable. After you correct the syntax, all parts are available again.

If the statement is the default statement template, all parts of the SQL builder remain available when the statement is incorrect.

You have three options to correct the syntax:
  • Correct the syntax manually.
  • Revert to the last known correct source.
  • Clear to the template code for the statement.

When you clear to the template code for the statement, the code in the SQL Source pane is replaced with the default statement for the statement type. For example, the default statement for a SELECT statement is: SELECT * FROM .

Prerequisites:
  • The SQL statement must be open in the SQL builder.
  • The Tables pane and the Design pane in the SQL builder are unavailable because the SQL Source pane contains code with unrecognized syntax.

To correct unrecognized syntax in an SQL statement in the SQL builder:

After you correct the unrecognized syntax, all the panes in the SQL builder are available again. You can continue working on the SQL statement, or you can save and close the statement.

Feedback