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
PowerBuilder dot notation:
dw_control.Object.columnname.Update
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
string setting
setting = dw1.Object.emp_name.Update
dw1.Object.emp_name.Update = "No"
setting = dw1.Describe("emp_name.Update")
dw1.Modify("emp_name.Update=No")