The SQL Query Builder supports saving and loading code
that contains
unrecognized syntax. When the parser encounters unrecognized syntax,
parts
of the SQL Query Builder become unavailable. After you correct the
syntax, all parts
are available again.
Before you begin
If the statement
is the default statement template, all parts of
the SQL Query 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 Query Builder.
- The Tables pane and
the Design pane in the SQL Query Builder are unavailable
because the SQL Source pane contains code with unrecognized syntax.
About this task
To correct unrecognized syntax in an
SQL statement in the SQL Query
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.
What to do next
After you
correct the unrecognized syntax, all the panes in the SQL Query
Builder are available again. You can continue working on the SQL statement,
or you can save and close the statement.