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
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 |