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 .
Before correcting
SQL statements in the SQL Query Builder, ensure you have the following configuration:
- 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.
Procedure
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.