Ariadne index page

 

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