Ariadne - Technical description
A600 |
Race results |
- to be updated to A480 (2010)
1. Description
Event results can be requested per event or for the competition as a whole. Once being processed, the event results are 'frozen'. This is done by writing them to a separate file T570-Saved-event-results. Saved results can be overwritted when required.
The results for the competition as a whole are available in a MS-Access report, as in html (for internet publication)
The Result request form displays all events. As required, the results for ony series 1 of for both series 1 + 2 can be requested. Run results which are not complete (which do not have elapsed time and penalty points entered) , are displayed at the bottom of the result list.
2. Access path
 F000-Menu |
|
 F570-Event-results |
|
| R530-Event-results-series1 |
|
| R531-Event-results-series1 |
|
| R126-PenaltyPoints-sub |
|
| R534-Event-results-series1+2 |
|
| R535-Event-results-series1+2 |
|
| R126-PenaltyPoints-sub |
(series 1) |
| R126-PenaltyPoints-sub |
(series 2) |
| R538-Event-results-competition |
|
| P535_Event-results_html |
|
| P536-Event_winners_html |
3. Function structure
3.1 form F570-event-results
The form shows all events, and per event, or for the competition event result reports can be requested.
| Form | Control | Action | Query | Table | Attribute |
| F570-Event-results | Q570-Event-results | T110-Program-block T400-Event |
|||
| listbox CurrentCompetition |
Q100-Current-competiton | T100-Current-competition | |||
| dropbox program-block-id |
Q112-Program-blocks-select | T110-Program-block | |||
| button ButtonShowEvent |
calls: depending on the 'feeze' indicator calls P570_Save_event_results connects to: R530-Event-results-series1 R534-Event-results-series1+2 |
||||
| dropbox program-block2 |
Q112-Program-blocks-select | T110-Program-block | |||
| button ButtonShowCompetition |
connects to: R538-Event-results-competiton |
||||
| button ButtonShowHtml |
connects to: P535_Event_results_html |
||||
| button ButtonClose |
3.2 Sub P570-Save-event-results
| Module | Function | Action | Query | Table | Attribute |
| P570-Save-event-results | P570_Save_event_results | for the specified event-id: - delete eventual results for this event in T570 - add the event results from Q572 |
Q572-Event-results-to-save | T450-Category-in-event T500-Competing-unit Q537-Elapsed-times-series1 Q538-Elapsed-times-series2 |
event-id |
3.3 Report R530-Event-results-series1
This report shows the results of the first series.
| Report | Control | Subreport | Query | Table | Attribute |
| R530-Event-results-series1 | Q530-Event-results | T100-Current-competition T110-Program-block T400-Even |
|||
| Event-results | R531-Event-results-series1 | ||||
| PenaltyPoints | R126-Penalty-points-sub | ||||
| Event | Action | Query | Table | Attribute | |
| on open | set filter to EventId make PenaltyPoints invisible when T100![Default-penalty-entry] = 1 |
| Report | Control | Subform | Query | Table | Attribute |
| R531-Event-results-series1-sub | Q531-Event-results-series1 | T020-Status-type T300-Kayak-club T500-Competing-unit T570-Saved-event-results Q503-Competing-unit-name |
|||
| Q503-Competing-unit-name | T500-Competing-unit Q504-CU-name1 Q505-CU-name2 Q506-CU-name3 |
||||
| Report | Control | Subform | Query | Table | Attribute |
| R126-Penalty-points-sub | Q126-PenaltyPoints-PerGate | T400-Event T450-Category-in-event T500-Competing-unit T510-Run T530-Gate-negatiation |
3.4 Report R534-Event-results-series1+2
This reports shows the event results of the first and second series together.
Depending whether an event has one or two series (T400-Event!Series),
the event total is calculated over one resp. two series.
| Report | Control | Subreport | Query | Table | Attribute |
| R534-Event-results-series1+2 | Q530-Event-results | T100-Current-competition T110-Program-block T400-Even |
|||
| Event-results | R535-Event-results-series1+2 | ||||
| PenaltyPointsSeries1 | R126-Penalty-points-sub | Q126-PenaltyPoints-PerGate | T400-Event T450-Category-in-event T500-Competing-unit T510-Run T530-Gate-negatiation |
||
| PenaltyPointsSeries2 | R126-Penalty-points-sub | Q126-PenaltyPoints-PerGate | T400-Event T450-Category-in-event T500-Competing-unit T510-Run T530-Gate-negatiation |
||
| Event | Action | Query | Table | Attribute | |
| on open | set filter to EventId make PenaltyPointsSeries1 and PenaltyPointsSeries1 invisible when T100![Default-penalty-entry] = 1 |
| Report | Control | Subform | Query | Table | Attribute |
| R535-Event-results-series1+2-sub | Q535-Event-results-series1+2 | T020-Status-type T300-Kayak-club T500-Competing-unit T570-Saved-event-results Q503-Competing-unit-name |
|||
| Q503-Competing-unit-name | T500-Competing-unit Q504-CU-name1 Q505-CU-name2 Q506-CU-name3 |
||||
| Report | Control | Subform | Query | Table | Attribute |
| R126-Penalty-points-sub | Q126-PenaltyPoints-PerGate | T400-Event T450-Category-in-event T500-Competing-unit T510-Run T530-Gate-negatiation |
3.5 Report R538-Event-results-competition
This reports shows the event results for a program block, or the the competition.
(But without penalty points per gate).
To be available on the results report for the competition as a whole, the results must be processed on an event basis, as this is the way the results are stored in the T570-Saved-event-results table.
| Report | Control | Subreport | Query | Table | Attribute |
| R538-Event-results-competition | Q530-Event-results | T100-Current-competition T110-Program-block T400-Even |
|||
| Event-results | R535-Event-results-series1+2 |
3.6 P535-Event-results-html
This function generates the event results for the competition in html format, for being published. The styling of the html report is controlled with a linked .css file (cascading style sheet).
To be available on the results report for the competition as a whole, the results must be processed on an event basis, as this is the way the results are stored in the T570-Saved-event-results table.
| Module | Function | Action | Query | Table | Attribute |
| P535-Event-results-html | P535_Event_results_html | determine the competition name | Q100-Current-competition | T100-Current-competition |
|
| write result lines to output | Q535-Event-results-series1+2 | T020-Status-type T300-Kayak-club T500-Competing-unit T570-Saved-event-results Q503-Competing-unit-name |
The structure of the module is:
- Open the file 'results.htm' in the Ariadne directory
- Write the html header
- Write the competition name as the results title
- Write per event an event header
- Write the event lines
- Write the html footer
Results.htm is for styling linked to Ariadne.css.
3.7 P536-Event-winners-html
Same as P535, but only the postion 1 line (the winner) is printed per event. The output file is 'winners.html'
Change history
| date | Ariadne version | change |
| 02 Apr 2005 | 4.3.0 | P536-Event-winners-html added |
| 09 Feb 2003 | 4.1.2 | Table T570-Saved-event-results introduced |
| 19-Dec-2002 | 4.1.0 | Ariadne 4.1, text converted to html |