Ora Developer Studio Table Update

Ora Developer Studio Table Update

Postby 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
wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Postby .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.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart


Return to dbForge for Oracle