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
Default
Unique