The Debug tab allows you into the innards of the program. Most people probably won't have much use this tab.
The Debug tab includes the following subtabs:
The SQL tab allows you to enter an arbitrary SQL command to the database. Pushing the Execute button will execute the SQL command and display the results in the Query Results output tab. A discussion of SQL is beyond the scope of this document.
The Change ID tab allows you to change the ID of a row, along with all records that reference that row. You can specify the table, the old ID and the new ID.
The Edit Field tab allows you to examine or modify the value of one field in the database. You can specify the table, the column and the WHERE clause to select the desired row. This is useful for making corrections to text fields containing a large amount of data.
The Foreign Keys tab helps in examining and updated references to other records via foreign keys. You can specify a table and two key (ID) values, then display the list of foreign key columns for the table, display the two rows, find references to them, and update either set of references to point to the other row.
The Properties tab allows you to examine or modify the values of Java System properties. Pushing the View Properties button displays the names and values of all system properties in the Help output tab. See the JDK documentation for information on Java System properties.
The Generate tab allows you to generate large numbers of Team and People records for the purpose of testing and debugging.
The Progress tab allows you to set up Races for an Event and progress those Events through their Stages, moving winning racers on to the next Stage and doing automatic lane assignments. This tab is obsolete, and is here only in case of bugs in the new code.
The Finish tab allows you to easily enter the finishing times or marks for a Race. This tab is obsolete, and is here only in case of bugs in the new code.
The Races tab allows you to examine the race records, making manual changes if necessary.
The Lanes tab allows you to examine the individual entries to each race, making manual changes if necessary.