Niggy G
HTAFC will rise again!!!
I’m designing a front end that will take a database of rom names (with a table for each system, n64, nes, etc) and populate a listbox.
This listbox has filters to filter JAP, EURO, USA, [!]. The filters are done using an SQL query.
I would like another filter that selects only unique games, e.g. the latest version of a game (Zelda OOT had 1.0, 1.1 etc). However I’m not sure how this could be done.
The only SQL query way I can think of is to compare the strings of games and then if the first so many characters are the same use the one with the higher index. (each record in the DB has an index). This won't work though because there a some games whose names are similar but they are different games (some sequels).
I wanted to use an SQL query as it would be quick, my only other thought would be to create a separate yes/no column in the database and check it if it is the unique version I want in the list. This would be very time consuming though especially as I want to do this for multiple systems.
I hope this wasn’t explained too poorly
Does anyone have any suggestions?
This listbox has filters to filter JAP, EURO, USA, [!]. The filters are done using an SQL query.
I would like another filter that selects only unique games, e.g. the latest version of a game (Zelda OOT had 1.0, 1.1 etc). However I’m not sure how this could be done.
The only SQL query way I can think of is to compare the strings of games and then if the first so many characters are the same use the one with the higher index. (each record in the DB has an index). This won't work though because there a some games whose names are similar but they are different games (some sequels).
I wanted to use an SQL query as it would be quick, my only other thought would be to create a separate yes/no column in the database and check it if it is the unique version I want in the list. This would be very time consuming though especially as I want to do this for multiple systems.
I hope this wasn’t explained too poorly
Does anyone have any suggestions?