Feature Request: Remember the selected rows and current row when sorting a table

[GaryMeyers1]

Is your feature request related to a problem? Please describe. On the Data view, sorting a table by clicking on a column header loses the current row that the user had selected. If there are multiple rows selected, the selections stay at their same locations instead of following the originally-selected rows to their new locations. This makes SQLPro much more difficult to use because the user needs to search for those previously-selected rows manually.

Describe the solution you'd like Before performing a sort, remember the selected rows and the current row. After the sort has been performed, loop through the selected rows and select them in their possibly-new locations. Select and scroll into the vertical middle of the grid the row that was the current row before the sort. I have done this in my Windows apps via a generic algorithm using strings but you have the advantage of knowing the primary key for every row in the table so this should be easier to implement.

Describe alternatives you've considered None.

Additional context

Environment (please complete the following information):

• Device: iMac
• OS: macOS Ventura 13.7.2
• SQLPro app Version: SQLPro for SQLite Version 2024.30 (Build 4374)