Added Tables not Showing in Alphabetical Order (FIX)

[ortizimo]

So I added some new tables to my VP cab and they show up at the end of the wheel for each letter instead of automatically set by letter order in their name. Luckily, I know SQL so here's the fix in case others are having the same issue.

 

• Go to PinUP Popper Config
• Click on Playlist Config
• If you have an alphabetical playlist (A-Z) then select the letter you need to fix
• Select the ActiveList tab to view your tables issues
• Select the Settings tab
• Add ORDER BY at the end of the SQL (this example is for the letter D)

 

select * from games where emuid=1 and GameName like "d%" and visible=1 ORDER BY GameName

 

If you click out of the letter and back again, then select the ActiveList tab again to see your tables are now fixed! Use this SQL for each letter...just change the "d%" to another letter.

 

Notes:

1. You cannot add the # to this...just create a # playlist and manually add the tables that start with numbers.
2. SQL doesn't need to be in all cabs...it works lower and upper case the same.
3. To sort by letters just add each letter as a playlist under the Emulator: e.g. FX3 > A