This form collects the Team Name, and optional fields of GameID and Games Played for processing both the batting and pitching modules.
The first thing you are presented is with a Team/Game Input Box. This box is used whenever you need to select a team. Other fields include a gameID and number of games.
Team Input Fields
There are 3 fields (as shown above) that are used to create the SQL SELECT statements:
| Team Name: | Selects the team that you want to process. (Required) |
| Game ID: | This field, used for updating purposes, allows you to provide a game number/identifier for use when updating a boxscore. (Optional) |
| Games Played: | This field, used for updating purposes, allows you to enter more than one game of stats. (Optional - if not provided, value defaults to 1) |
If Team Name is missing, The program will display a warning message box (below) and re-display the form again, and clearing all values previously entered.
If you provide a team name that does not exist in the SQL Table, you will receive an empty boxscore display for either the hitting or pitching statistics. This is done on purpose as this may be the first time you are adding a team. It is up to you to make sure the team name is correct, for once updated, in this release, there is only one way to change it in the SQL Table - using mySQL Workbench to manually change your table values. A future release will give you individual record editing/deleting abilities. For now, become familiar with either "MySQL Workbench" or "dbeaver-ce" (Community Edition), both are free packages and available for Linux distro's.
