I need some help with a project I'm working on. I need to make an information kiosk program for a hypothetical game reserve. The kiosk will display a list of 24 different bird species, and when the user clicks on a bird, information about it will be displayed.
I have all the information about each bird stored in an Access database (with SpeciesNumber as the primary key.) When the user clicks on a bird, the program must select all the fields relating to the chosen bird from the database, and store each field as an attribute of a class.
I can't quite figure out how to do this. I've planned to have a variable (iSpeciesNumber), which would be stored with a specific number depending on which bird button was selected. Then I imagine I would need a query component:
"Select * from BirdsTbl where SpeciesNo = " + iSpeciesNumber
But then I'm not sure how to store the fields into attributes. Usually when I work with SQL in Delphi, I have a DBGrid component to display the queried fields - but now I need the fields to be stored directly into a class.
Any help would be greatly appreciated.