Update Column Values dialog box
Description
Specify column values for an UPDATE statement.
Options
Column Name
Click the name of the column you want to update in the table representation
at the bottom of the dialog box. To specify values for additional columns,
click in the empty box at the bottom of the Column Name list and then
select another column name from the table representation. Use the
Insert button to add a column elsewhere in the list.
Value
Enter the variable or value you want to use to update the
column. You can select variables from the list in the Program Variables
drop-down list. The Value can be an expression (for example, :salary_amt * .07)
.
Operator buttons
Click an operator button to paste it into the expression in the
Value box.
Program Variables
Double-click a variable to paste it into the expression in the
Value box.
Null
Click to make the value an explicit NULL.
Clear
Click to clear the values specified for all columns.
Delete
Click to delete the selected column from the list.
Insert
Click to insert a new column in the Column Name list above
the currently selected name. A blank box opens for the new column
name.