How to Sort MM database table within a script
Posted: Wed Feb 08, 2023 2:48 pm
I mistakenly posted a question in the "Need Help? (MMW4)"viewtopic.php?t=103686 when it should have been posted here, so this is a multiple posting. Sorry.
I have a script that accesses the entire Songs table my first selecting Music in the media tree, performing whatever sort I wish, and running the script containing
I would rather do the sort in the script so the correct sort gets performed regardless of what has been in the media tree. I suspect there is a standard SQLite call to do this, but I'm not fluent in SQLite access from VBS (or from anywhere else for that matter). How do I programmatically perform a sorted extraction of data from the database?
I have a script that accesses the entire Songs table my first selecting Music in the media tree, performing whatever sort I wish, and running the script containing
Code: Select all
Set list = SDB.AllVisibleSongList