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

Update Changed Columns Only Property

Description

When queried records have been marked as updates, specifies that only columns whose values were actually changed should be included in the SQL UPDATE statement that is sent to the database during a COMMIT. By default, Update Changed Columns Only is set to No, and all columns are included in the UPDATE statement.

Applies to block

Set Oracle Forms, programmatically

Refer to Built-in

GET BLOCK PROPERTY

SET BLOCK PROPERTY

Default

No

Required/Optional optional

Usage Notes