Editing showing two result sets does not always work.

[Claus Pedersen]

In an SQL window I have the two selects (using schema 'hr'):

SELECT t.*, rowid FROM employees t;

SELECT t.*, rowid FROM jobs t;

I select them both, execute and Ctrl-click the first tab page to show the two result sets in the same page. The employee table is now shown in the lower half of the screen.

I click the red lock icon to edit data. I modify data in the employee table and Ctrl-click the green Post checkbox to post and commit data.
But nothing is saved.

The same thing happens when I select for update. I can edit the data in the employee table, bot nothing is saved. The changes I make to the 'jobs' table are always saved.

Please correct this, so table data can be maintained in both grids.

 

[Marco Kalter]

We'll check it out. Note that you will only be able to update the data in the primary (top) result set. The secondary result sets will be read-only.

 

[Claus Pedersen]

This has been fixed in beta 7/8