Claus Pedersen
Member³
When rows in SQL grid are sorted, inserted records are always inserted after the marked row. Normally new records are inserted at the top (where the focus is).
When you have more records than can be displayed in a single screen, this is annoying, as you have to scroll to find the inserted record.
Steps to reproduce:
Right-click on a table with many rows in the object browser and select Edit data. This opens an SQL Window with the select:
select t.*, t.rowid from MY_TABLE t
Now, sort the rows using the small squares in the column headers, e.g. the first column descending.
The rows are sorted and the black arrow indicating the current row is moved with the row that was originally the first. When this row is out of screen focus, new records are also inserted out of screen focus and you have to scroll to find the inserted row (and the black arrow).
Please either always keep the black arrow pointing to the top-most row, even after sorting, so new records always are inserted at the top of the screen or somehow indicate where the current row is (maybe by using the middle field in the status bar that now only contains 0:01, whatever that means?) . In tables with more than e.g. 100 records is can be tricky to find the inserted row without an indicator.
When you have more records than can be displayed in a single screen, this is annoying, as you have to scroll to find the inserted record.
Steps to reproduce:
Right-click on a table with many rows in the object browser and select Edit data. This opens an SQL Window with the select:
select t.*, t.rowid from MY_TABLE t
Now, sort the rows using the small squares in the column headers, e.g. the first column descending.
The rows are sorted and the black arrow indicating the current row is moved with the row that was originally the first. When this row is out of screen focus, new records are also inserted out of screen focus and you have to scroll to find the inserted row (and the black arrow).
Please either always keep the black arrow pointing to the top-most row, even after sorting, so new records always are inserted at the top of the screen or somehow indicate where the current row is (maybe by using the middle field in the status bar that now only contains 0:01, whatever that means?) . In tables with more than e.g. 100 records is can be tricky to find the inserted row without an indicator.
