Page 1 of 1

Editing filtered data via grid: wrong values are displayed

Posted: Fri 21 Aug 2015 07:31
by wcdevart3
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

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

Posted: Fri 21 Aug 2015 08:41
by alexa
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

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

Posted: Fri 21 Aug 2015 08:53
by wcdevart3
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

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

Posted: Fri 21 Aug 2015 09:55
by alexa
We will investigate this issue and will answer you as soon as possible.

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

Posted: Thu 04 Feb 2016 14:50
by alexa
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.