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

Key Mode Property

Description

Specifies how Oracle Forms uniquely identifies rows in the database. This property is included for applications that will run against non-ORACLE data sources. For applications that will run against ORACLE, use the default setting.

By default, the ORACLE database uses unique ROWID values to identify each row. Non-ORACLE databases do not include the ROWID construct, but instead rely solely on unique primary key values to identify unique rows. If you are creating a form to run against a non-ORACLE data source, you must use primary keys, and set the Key Mode block property accordingly.

Value

Description

Automatic (default)

Specifies that Oracle Forms should use ROWID constructs to identify unique rows in the datasource but only if the datasource supports ROWID.

Non-Updateable

Specifies that Oracle Forms should not include primary key columns in any UPDATE statements. Use this setting if your database does not allow primary key values to be updated.

Unique

Instructs Oracle Forms to use ROWID constructs to identify unique rows in an ORACLE database.

Updateable

Specifies that Oracle Forms should issue UPDATE statements that include primary key values. Use this setting if your database allows primary key columns to be updated and you intend for the application to update primary key values.

Applies to block

Set Oracle Forms, programmatically

Refer to Built-in

GET_BLOCK_PROPERTY

SET_BLOCK_PROPERTY

Default

Unique

Usage Notes