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:
- Manually correct the code that contains the unrecognized syntax.
- Revert to the last known correct source.
- Right-click in the SQL Source pane, and then click Revert
to Last Correct Source on the pop-up menu. A
window that shows the last correct source opens.
- Click OK to revert to this source or Cancel to
keep your current source.
- Clear to the template code for the statement. Right-click in the
SQL Source pane and then click Clear to Template on
the pop-up menu.
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.