It is a follow up of my listview sorting madness.
So there is a huge list and I want to display it the most convinient way for the user perspective.
Today I made a very nice approach of the problem:
Put the data to an SQLite database and display only just the visible rows of a query of the database.
It gives extreme flexibility on sorted, filtered data.
The gui part contains a listview with scrollerpos="none", a scrollbar and a string gadget.
The scrollbar sets the LIMIT and OFFSET part of the SELECT sql query and the string gadget sets the LIKE option.
Now the problems:
1.
When the listview's visible lines are changes, the query should be changed too, but MUIRoyale has no notification for this.
It is already discussed before here: viewtopic.php?f=27&t=2038&p=10646&hilit ... ize#p10660
The workaround is to display a minimal hollywood display and get the SizeWindow event from there.
2.
This custom listview can't be controlled with the mouse and the keyboard because there is no notifications for moving the list without
changing selection. I can't find any workaround this. Acceleration class of RapaGUI could solve the keyboard handling, but the mousewheel for a listview is so essential that can't be leave unworkable.
If these notifications can be added to a future MUIRoyale that will be make a very powerful combo of SQLite and the GUI.
Here is a small and crap video that shows the thing: https://youtu.be/GuEB_e9mxxM