SQL window: sorting after inserting new row can erase data and make last row dissappear?

Claus Pedersen

Member³
Steps to reproduce:

On schema SCOTT, right-click on table EMP, select Edit data.
In the resulting SQL grid, place cursor in the lower blank row.
Sort by EMPNO by clicking on the square to the right in the column header.
The new row is now at top, but the new row indicator (*) is at the last row (in my case for EMPNO=7934, MILLER).
If I navigate to row two (labelled 1) by mouse or keyboard, my data is erased (blanked) and the last row disappears (?). If I navigate back to the new row, the last row appears again, but my entered data is gone.

I am using version 11.0.4.1775
 
Back
Top