Update

Description

Whether the specified column is updatable. Each updatable column is included in the SQL statement that the Update method sends to the database. All updatable columns should be in the same database table.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.Update { = value }"

Parameter

Description

columnname

The column for which you want to get or set the updatable status

value

Whether the column is updatable.

Values are:

  • Yes – Include the column in the SQL statement for updating the database.

  • No – Do not include the column in the SQL statement.

Usage


In the painter

Set the value using Rows>Update Properties, Updateable Columns option.

Examples

Example 1

setting = dw1.Describe("emp_name.Update")

dw1.Modify("emp_name.Update=No")