A script-enabled browser is required for this page to function properly.

Update Permission Property

Description

Setting Update Permission to No performs the following three actions:
  1. Sets the Update If Null property to No.
  2. Sets the Update Allowed property to No.
  3. Specifies that this column should not be included in any UPDATE statements issued by Oracle Forms by removing that column from the SET clause of the UPDATE statements.

Setting Update Permission to Yes performs does the inverse of (2), but not of (1); that is, it adds the item to UPDATE statements issued by Forms, but it has no effect on the Update Allowed and Update If Null properties.

Also, UPDATE statements are affected only if the Enforce Column Security property of the block is set to TRUE.

Applies to all items except buttons and chart items

Set programmatically

Refer to Built-in

GET ITEM PROPERTY

SET ITEM PROPERTY

Default

Yes

Required/Optional optional

Usage Notes


Enforce Column Security property