Ariadne index page

 

Ariadne - Technical description

A430

Competing unit

1. Description

On this form it is possible to change almost everything of a competing unit (= entry), including adding and deleting a competing unit.

A competing unit can be selected via start number or via participant name.

Via the button next to the participant field you switch to the F230-Select-person form. On this form, a person/participant can be selected or added.

Via the button next to the club field you switch to the F310-Club-details form. Eventual new clubs can be added on this form. Returning from the F310-Club-details form, the club-id is put in the club field.

Via the button next to the Race field, you switch to the F490-Entries-per-race form to see all entries for this race.

Via the button next to the Penalty points field you switch to the F525-Penalty-points form, where you can change the penalty points fot that run.

Via the button next to the status field you switch the the F515-Set runstatus form, where you can set abnormal run statusses as 'Did not finish' and 'Disqualified', or revert these back to normal.

F000-Menu  
F510-Competing-unit  
F505-Participant1  
F505-Participant2  
F505-Participant3  
F512-Run-results-series1 With Ariadne marathon F512 and F514 are replaced by
F514-Run-results-series2 F516-Run-results

1.1 Screen shot

F510-Competing-unit

2. Function structure

Only the participant subforms are displayed which are relevant for the competing unit type. e.g. When the CU-type-participants = 1 (solo), only the participant1 subform is displayed.

Form Control Subform Query Table Attribute
F510-Competing-unit     Q510-Competing-unit T500-Competing-unit  
  listbox
CurrentCompetition
  Q100-Current-competiton T100-Current-competition  
  Dropbox
NameSelect
  Q514-Name-select T400-Race
T450-Category-in-race
T500-Competing-unit
Q503-Competing-unit-name
competing-unit-id
  Dropbox
StartNumberSelect
  Q512-Start-number-select T500-Competing-unit
Q503-Competing-unit-name
competing-unit-id
  Dropbox
start-number
  Q051-Available-startnumbers T050-Start-number
T500-Competing-unit
start-number
  Subform
Participant1
F505-Participant1     competing-unit-id
  Subform 4)
Participant2
F505-Participant2     competing-unit-id
  Subform 4)
Participant3
F505-Participant3     competing-unit-id
  dropbox
category-id
  Q416-event-select-via-category T040-Category
T400-Race
T450-Category-in-race
category-id
  dropbox
club-id
  Q302-Club-select T300-Club -club-id
  button
ButtonClub
connects to:
F310-Club-details
    ClubId
  subform
Series1
F512-Runresults-series1     competing-unit-id
  subform
Series2
F514-Runresults-series2     competing-unit-id
  checkbox
Locked 2)
       
  button
ButtonDelete
deletes the competing-unit record      
  button
ButtonSave
saves the competing-unit      
  button
ButtonClose
closes the F510 form      
  Event Action Query Table Attribute
  Form load put tab page Runresults or Rankinghistory in the front, depending on T100![pre-entries-closed] Q100-Current-competition T100-Current-competition  
  After insert add T510-Run records:
P510_Add_runrecords
     

2) When the checkbox "Locked" is true, no fields can be changed. When the checkbox is false, fields can be updated. This mechanism is introduced to prevent changes by accident.
4) These subforms are made visible / invisible depending on the competing unit type. e.g. if competing unit type is 'solo', only the participant 1 is displayed. with 'duo' participant1 and participant2 is displayed, with 'team' all three participants are displayed.

Module Function Subform Query Table Attribute
P510-Add-runrecords P510_Add_runrecords     T510-Run competing-unit-id

P510-Add-runrecords checks per series for a competing unit if T510-runrecords are present. If not, run records are added.

SubForm Control Subform Query Table Attribute
F505-Participant1     Q231-CU-Person-id-1 T230-Participant
Q206-Person-display
competing-unit-id
      Q206-Person-display T200-Person  
  button
ButtonParticipant
connects to:
F230-Select-person
    TS_ObjectId = person-id
SubForm Control Subform Query Table Attribute
F505-Participant2     Q232-CU-Person-id-2 T230-Participant
Q206-Person-display
competing-unit-id
      Q206-Person-display
T200-Person
 
  button
ButtonParticipant2
connects to:
F230-Select-person
    TS_ObjectId = person-id
SubForm Control Subform Query Table Attribute
F505-Participant3     Q233-CU-Person-id-3 T230-Participant competing-unit-id
      Q206-Person-display
T200-Person
 
  button
ButtonParticipant3
connects to:
F230-Select-person
    TS_ObjectId = person-id


Form Control Subform Query Table Attribute
F512-Runresults-series1     Q516-Runresults-series1 T510-Run  
  button
PenaltyPoints
connects to:
F525-Penalty-points
     
  button
setRunStatus
connects to:
F515-Set-runstatus
     
  dropbox
status-id
  Q020-Status-select T020-Status-type  

 

Form Control Subform Query Table Attribute
F514-Runresults-series2     Q518-Runresults-series2 T510-Run  
  button
PenaltyPoints
connects to:
F525-Penalty-points
     
  button
setRunStatus
connects to:
F515-Set-runstatus
     
  dropbox
status-id
  Q020-Status-select T020-Status-type  

With Ariadne Marathon F512 and F514 are replaced by F516:

Form Control Subform Query Table Attribute
F516-Runresults     Q516-Runresults T510-Run  
  button
setRunStatus
connects to:
F515-Set-runstatus
     
  dropbox
status-id
  Q020-Status-select T020-Status-type  

 

(30-07-01): The value of the runstatus cannot be changed manually. The status is derived from the content of elapsed time and penalty points as shown below:

Run status Penalty points  
Elapsed time no T530 record for run-id T530 record present for run-id
null (empty) status = -1 (initialized) status = 1 (started)
value (not null) status = 2 (finished) status = 3 (complete)

(04-Mar-2004): The penalty points total is added to the T510-Run table, and shown on the F512, F514 forms. This field can not be updated on these forms, but is derived from the penalty points entered on the F525-Penalty-points form.


Change history

date version change
30 May 2004 1.11 F516 for marathon added
14 Mar 2004 1.10 button Abnormal run status added
04 Mar 2004 1.9 Ariadne 4.2.0. Person selection via F230, total penalty points added in T510-Run
07 Mar 2003 1.8 Subform Runhistory and tab-control removed. It is easy to click on the button 'participant1'etc. to see the archived results of that person.
09 Feb 2003 1.7 Button ButtonKayakClub added
31 Jan 2003 1.6 F505-Participant subforms added, and making them selectively visible
10 Dec 2002 1.5 Ariadne 4.1, text converted to html