Use the panes in the SQL builder to create an UPDATE statement.
An UPDATE statement updates data in a table either by using the
values that you specify or with the results from a query.
- SQL Source pane
- Use this pane to review the UPDATE statement as
you build the statement in the Tables pane and the Design pane. You can
also type changes directly in this pane. If you change the statement in this
pane, you can parse the statement by moving the focus out of the pane or by
saving the statement. If the parser considers the statement syntax valid,
the Tables and Design pane are synchronized to reflect the updated statement.
- Tables pane
- Use this pane to add a table to the UPDATE statement.
You can also select columns in this pane. After you add a table, to add
columns to the UPDATE statement, select their check boxes in the table graphic.
- Design pane
- Use the fields and pages in this pane to define
elements in the UPDATE statement.
- Statement
- The name of the UPDATE statement.
- Set
- Use this page to specify a SET clause in the UPDATE
statement. The SET clause specifies which columns to update and calculates
new values for them.
- Where
- Use the grid on this page to specify the conditions
that control which rows of the database to update.