Chapter 3: DataWindow Object Properties

Update

Description

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

Applies to

Column controls

Syntax

PocketBuilder 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.

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, Updatable Columns option

Examples

Example 1

string setting

setting = dw_1.Object.emp_name.Update

Example 2

dw_1.Object.emp_name.Update = "No"

Example 3

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

Example 4

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

View this book as PDF