Update changed columns

In Oracle Forms 4.5 there is a block property 'Update changed columns'. Default it is False which means that all columns are updated. When set to True, only the changed columns are updated. For normal situations Oracle recommends the default setting. However, because all columns are updated, this includes the primary key column(s). When there are foreign key constraints in the database, an update of the primary column(s) will also update and therefore lock underlying tables. If, in addition, there is no index on the foreign key involved of an underlying table, this table is locked entirely. This can result in other users waiting for their locks. What are the experiences of other Oracle developers/users? In addition, is there a way to change the default setting of this property when generating forms with Designer/2000?

Wim Blanken Received on Sat Mar 22 1997 - 00:00:00 CST