How Do I...
To interactively create SQL syntax for an UPDATE statement:
- Select Create > UPDATE from the
Query menu of the SQL Statement - Settings window. The
UPDATE Details window is displayed, with the tables and views of the database
defined in the connection specification listed in the Table/view
drop-down list.
- Type a name for the query in the Query name text entry
field. The name must be unique within a particular access set, and it
cannot contain double-byte characters.
- Type a description for the query in the Description text entry
field. (The description is optional.)
- Use the list panes and menus in the UPDATE Details window to define the
tables, columns, and clauses to be included in the query. For
instructions on using this window, see the VisualAge base help.
- Select WHERE clause to specify the WHERE clause of the UPDATE
statement.
- To save your query, select Apply.
Your query is saved in the access set and you are returned to the SQL
Statement - Settings window. The name and description of your query are
displayed in the Query name drop-down list and
Description text field, respectively.
[ Top of Page | Previous Page | Next Page | Table of Contents ]