|
Ariadne - Technical description
Description
In clocking marathon finishtimes, it sometimes happens that a finishtime
is assigned to a wrong CU/startnumber. When the competing unit (CU) with
that startnumber finishes later on, that finish has to be assigned to
a dummy CU, because that startnumber was wrongly assigned a finish earlier.
These mis-assignments must be corrected before the results can be published.
The AM480 function provides a swapping facility to swap the finishtimes
of two CU's. For tracebility reasons, the swappings are logged in a log
table. The two CU's between which the finish times can be swapped are
called A_CU and B_CU.
Access path
F000-Menu |
|
 F480-Finishtime-swap |
|
 F481-Finishtime-swap-sub |
|
Function structure
| Form |
Control |
Subform, action |
Query |
Table |
Attribute |
| F480-Finishtime-swap |
|
|
Q480-Finishtime-swaplog |
T480-Finishtime-swaplog
T500-Competing-unit |
|
| |
dropbox
A_CU_id |
|
Q512-Start-number-select |
T500-Competing-unit
Q503-Competing-unit-name |
|
| |
dropbox
B_CU_id |
|
Q512-Start-number-select |
T500-Competing-unit
Q503-Competing-unit-name |
|
| |
subform
A_CU |
F481-Finishtime-swap-sub |
|
|
|
| |
subform
B_CU |
F481-Finishtime-swap-sub |
|
|
|
| |
button
buttonSwap |
action (1) |
|
|
|
| |
button
buttonClose |
closes the form |
|
|
|
Action (1) - swapping of the T510-Run records of A_CU and B_CU.
- get the T510-Run!run-id's of A_CU and B_CU
- update competing-unit-id in T510-Run of A_CU to competing-unit-id of
B_CU
- update competing-unit-id in T510-Run of B_CU to competing-unit-id of
A_CU
- write the finishtimes of A_CU and B_CU before the swap to T480-Finishtime-swaplog
| Form |
Control |
Subform, action |
Query |
Table |
Attribute |
| F481-Finishtime-swap-sub |
|
|
Q481-CU-name-finishtime |
T510-Run
Q503-Competing-unit-name |
|
Change history
| date |
version |
change |
| 24-Aug-2004 |
4.2.5 |
Function new added. |
|