Ora Developer Studio Table Update

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wjm4
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Ora Developer Studio Table Update

Post by wjm4 » Thu 24 Mar 2011 20:13

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

.jp
Devart Team
Posts: 307
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Fri 25 Mar 2011 13:42

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.

Post Reply