Updating column values

Use the Update page to specify the values that you want to change in the specified table. When you update values, the values that you specify on the Update page are placed into the table specified on the Tables page.

../rule.gif

To specify the values to change, in the Value field, type the value that will be updated for that column.

You do not have to update all the values in a row; you only need to enter values for the columns that you want to update.

You must enter a value for at least one column.

../rule.gif

Related information

Update page - Fields and controls

Specifying the tables for an SQL statement

Specifying search conditions for rows

Verifying the SQL statement

Completing your SQL statement

Remapping data to another SQL data type

Creating SQL statements with SQL Assist

Logging on to SQL Assist

Selecting the type of SQL statement to create