Ariadne index page

 

Ariadne - Technical description

A480

Finishtime swap

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.