Page 1 of 1
Ora Developer Studio Table Update
Posted: Thu 24 Mar 2011 20:13
by wjm4
When updating values of a column for a table in the data editor, if 2 identical rows exists, both get update when I am only intending on updating 1 row. It seems Ora Dev Studio is using values within a row to update instead of using the unique row id to update a table in the data tab of a table. Is this the intended functionality? Is there a setting that can change this?
Thanks
Posted: Fri 25 Mar 2011 13:42
by .jp
Thank you for your post.
It seems Ora Dev Studio is using values within a row to update
instead of using the unique row id to update a table in the data tab of a table.
Is this the intended functionality?
Yes, OraDeveloper Studio uses a complete set of the selected columns
in the WHERE section to update table records without unique key in Data Editor.
If a record is not unique, all records satisfying the condition will be changed.
Is there a setting that can change this?
This situation cannot be changed.
Maybe this functionality will be implemented in the new version of the product.