Posted By
George
on 2018-01-20
10:31:10
 |  Re: Suggestions/Wishes for Game-Database Search
Hi Csabo,
i understand what you mean. If its too much effort for you, it doesn't make sense of course.
The idea behind all of this:
Collectors l want explore what is missing in their collection.
Examples:
* Which and how many commercial Cart exist
* Which and how many commercial Floppies exist
* Which and how many commercial Tapes exist
Category Games, Office-Application etc..
I would be nice to run a search where as result a list of covers, a photo of the cart, Floppy, Tape with the basic Information appears, because the package and the storage medium is more intersting then the software itsself. Collectors are interested in the physical things.
I work everyday with dynamic SQL-Queries.
A simple way would be to place an edit-field for the most important Datafields (like Distribution) in the Main-Searchform , where you can write a string in it. Example for the the Datafield 'Distribution'. The user would write "Commercial 'in it. The Query would be dynamically expanded with a ' WHERE ... AND Distributon LIKE %'+ Edit.Value +'% ' Clause, if the Edit field has a value.
This way over time you can add more and more dynamically 'AND/OR' clauses into your Main-Search for the software.
|
