|
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:
| 1. | Start the SQL Definer specifying statement type Insert (see "How to Start the SQL Definer"). |
| 2. | Select the table you want to insert into (see "How to Select Tables"). |
| 3. | Specify output columns (see "How to Specify Output Columns"). |
| 4. | Select the Column Definitions tab in the Select List pane. |
| 5. | 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:
| 1. | Start the SQL Definer specifying statement type Update (see "How to Start the SQL Definer"). |
| 2. | Select the table you want to update (see "How to Select Tables"). |
| 3. | As output column, specify the column you want to update (see "How to Specify Output Columns"). |
| 4. | Select the Column Definitions tab in the Select List pane. |
| 5. | Specify a value in the Value field. You can either enter a constant or an expression. |
|
