|
See
Also
If you are building an INSERT
or UPDATE statement, there is a field named Value on the Column
Definitions tab in the Select List pane.
To specify values in an INSERT
... VALUES statement:
|
·
|
Start the SQL Definer specifying statement type Insert (see
"How to Start the SQL Definer"). |
|
·
|
Select the table you want to insert into (see "How to Select
Tables"). |
|
·
|
Specify output columns (see "How to Specify Output
Columns"). |
|
·
|
Select the Column Definitions tab in the Select List pane. |
|
·
|
For each output column, specify a value in field Value. You can
either enter constants or expressions. |
To specify a value in an
UPDATE ... SET statement:
|
·
|
Start the SQL Definer specifying statement type Update (see
"How to Start the SQL Definer"). |
|
·
|
Select the table you want to update (see "How to Select
Tables"). |
|
·
|
As output column, specify the column you want to update (see
"How to Specify Output Columns"). |
|
·
|
Select the Column Definitions tab in the Select List pane. |
|
·
|
Specify a value in the Value field. You can either enter a
constant or an expression. |
|
