Ariadne - Technical description
A650 |
Race results |
1. Description
Race results can be requested per race, per program block or for the competition as a whole. Once being processed, the race results are 'frozen'. This is done by writing them to a separate file T620-Saved-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 the races which have show-results indicator = yes.. 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 |
|
 F620-Results |
|
| F622-Results-sub |
|
| R620-Results-competition-single-series-slalom |
|
| R639-Race-results-competition-slalom |
|
| R641-Race-results-single-series-wwrace |
|
| R635-Race-results-single-series-wwsprint |
|
| R637-Race-results-double-series-wwsprint |
3. Function structure
3.1 form F620-Results
The form shows the races/ series per program block, and per race/ series , or for the competition result reports can be requested.
| Form | Control | Action | Query | Table | Attribute |
| F620-Results | Q110-Program-blocks | T110-Program-block |
|||
| listbox CurrentCompetition |
Q100-Current-competiton | T100-Current-competition | |||
| list box ProgramBlockSelect |
Q112-Program-blocks-select | T110-Program-block | |||
| subform series |
F622-Results-sub | program-block-id | |||
| button buttonProgramBlock |
connects to: Reports corresponding to T024-Sports-discipline results report columns |
||||
| button buttonShowCompetition |
connects to: R639, R637 reports |
||||
| button ButtonClose |
3.1 form F622-Results-sub
The form shows the races/series per program block. Per series result reports can be requested.
| Form | Control | Action | Query | Table | Attribute |
| F620-Results | Q620-Series-for-results | T110-Program-block T400-Race T410-Series T024-Series-type |
|||
| button ButtonDetails |
open F405-Race-details |
||||
| button buttonEntries |
open F490-Entries-per-race |
||||
| dropbox series-type-id |
Q023-Series-type | ||||
| dropbox results-status-id |
Q021-Results-statustype | ||||
| button buttonRunInfo |
open R650 or R652 |
||||
| button ButtonShowResult |
call P620_Save_results open report spec according to T023-Series-type |
3.2 Module P620-Results-sub
| Module | Function | Action | Query | Table | Attribute |
| P620-Save-results | P620_Save_results | for the specified series-id: - delete eventual results for this event in T620 - add the event results from Q615 or Q616 |
Q615-Series-results-slalom or Q616-Series-results-wwrace |
series-id | |
3.3 Race / Series Results Reports
The results reports are specific to sports discipline / series type. The report types are specified in T023-Series-type table.
Unofficial results
R630-Race-results-single-series-slalom
R632-Race-results-double-series-slalom
R641-Race-results-single-series-wwrace
R635-Race-results-single-series-wwsprint
R637-Race-results-double-series-wwsprint
Official results
R639-Race-results-competition-slalom
R620-Results-competition-single-series-slalom
R641-Race-results-single-series-wwrace
R635-Race-results-single-series-wwsprint
R637-Race-results-double-series-wwsprint
3.5 Competition Results Reports
The results reports are specific to sports discipline. The report types are specified in T024-Sports-discipline table.
R639-Race-results-competition-slalom
R620-Results-competition-single-series-slalom
R637-Race-results-double-series-wwsprint
3.6 Results in html
(Only Ariadne marathon). This function generates the race 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 T620-Saved-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 | Q324-Club-with-entries Q531-Event-results-series1 |
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.
Change history
| date | Ariadne version | change |
| Jan2016 | A5.4 | reviewed and updated |
| Apr2005 | 4.3.0 | P536-Event-winners-html added |
| Feb2003 | 4.1.2 | Table T570-Saved-event-results introduced |
| Dec2002 | 4.1.0 | Ariadne 4.1, text converted to html |