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
Editing filtered data via grid: wrong values are displayed
Re: Editing filtered data via grid: wrong values are displayed
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
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
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
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
We will investigate this issue and will answer you as soon as possible.
Re: Editing filtered data via grid: wrong values are displayed
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.
Thank you for your help in improving dbForge Studio for Oracle.