Editing filtered data via grid: wrong values are displayed

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wcdevart3
Posts: 7
Joined: Tue 11 Aug 2015 10:24

Editing filtered data via grid: wrong values are displayed

Post by wcdevart3 » Fri 21 Aug 2015 07:31

We used a subselect to filter the rows of a table which we want to edit; here a simple example to reproduce the problem with an existing table:
SELECT * from testtable WHERE testcolumn in (SELECT testcolumn from testtable);

Then we use the grid to edit values -> after editing values and leaving the row to update:
The changes in the database are done correctly -> ok
But the just changed row in the grid is reloaded/redisplayed with wrong values -> not ok

Sometimes only the edited field is affected, sometime multiple columns of the changed row are displayed with strange values.

When Executing the whole Sql again, then the real data is loaded again and the correct values are displayed. But in this case you cannot trust the displayed values during editing -> not good

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Editing filtered data via grid: wrong values are displayed

Post by alexa » Fri 21 Aug 2015 08:41

Could you describe the steps to reproduce this issue in details along with the query and the CREATE definitions of the tables that are present in the query. Screenshots would be also of help.

Please also specify the full version of the product.

You can send a reply straight to our support system at supportATdevartDOTcom

wcdevart3
Posts: 7
Joined: Tue 11 Aug 2015 10:24

Re: Editing filtered data via grid: wrong values are displayed

Post by wcdevart3 » Fri 21 Aug 2015 08:53

Step1 & 2:
CREATE TABLE TESTTABLE (
TESTCOLUMN VARCHAR2(50 BYTE),
TESTCOLUMN2 VARCHAR2(50 BYTE),
CONSTRAINT PK_TESTTABLE PRIMARY KEY (TESTCOLUMN));

INSERT into TESTTABLE VALUES ('xx', 'yy');

Step3 new Sql:
SELECT * from testtable WHERE testcolumn in (SELECT testcolumn from testtable);

Step4:
Change xx of testcolumn to zz in the grid and leave the row. Column TestColumn2 turns to (null).

Version:
Trial of dbForge Studio for Oracle: 3.7.472

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Editing filtered data via grid: wrong values are displayed

Post by alexa » Fri 21 Aug 2015 09:55

We will investigate this issue and will answer you as soon as possible.

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Editing filtered data via grid: wrong values are displayed

Post by alexa » Thu 04 Feb 2016 14:50

We would like to let you know that dbForge Studio for Oracle, v3.8, where the issue you reported is fixed, is available for downloading https://www.devart.com/dbforge/oracle/s ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.

Post Reply