Ariadne - Technical description
A210 |
Races |
Description
Adding, updating and deleting of races in a program block, determining of the race order, assigning categories to races, splitting or joining races.
The table relation between T400-Race and T450-Category-in-race is set to 'check referential integrity' and 'cascading update'. This means that when a race is deleted, the related records in T450 are also deleted. This is OK. It is accordance with the users view, who normally do not know of the relation table T450.
(020202): An race number sub is added. With this sub it is possible to split races, while the parts can be kept together in the same progam block. E.g. a race23 can be split in 23 and 23a.
Access path
 F000-Menu |
|
 F400-Races |
|
| F410-Race-details |
|
|
Function structure
Sorting order is: program block, event number
| Form | Control | Subform | Query | Table | Attribute |
| F400-Races | Q400-Races | T110-Program-block T400-Race |
|||
| listbox CurrentCompetition |
Q100-Current-competiton | T100-Current-competition | |||
| dropbox ProgramBlock |
Q112-Program-blocks-select |
T110-Program-block | program-block-id | ||
| dropbox NumberEntries |
Q509-Number-of-entries-per-race | T400-Race T450-Category-in-race T500-Competing-unit |
event-id | ||
| button Details |
connects to F410-Race-details |
RaceId *) | |||
| button Entries |
connects to F506-Entries-per-racw |
RaceId *) | |||
| button ButtonResort |
requeries Q400 | ||||
| button ButtonClose |
*) Public variable
| Form | Control | Subform | Query | Table | Attribute |
| F410-Race-details | Q410-Race-details | T400-Race | |||
| listbox CurrentCompetition |
Q100-Current-competiton | T100-Current-competition | |||
| dropbox EventSelect |
Q412-Race-select | T400-Race | race-id | ||
| subform RaceCategories |
F412-Category-in-race | race-id | |||
| subform Remark |
F010-Remarks | remark-id *) | |||
| button ButtonClose |
1) remark-id of F010-Remarks is event-id prefixed with "E" .
| Form | Control | Subform | Query | Table | Attribute |
| F412-Category-in-race | Q450-Category-in-race | T400-Race T450-Category-in-race |
race-id | ||
| dropbox Category |
Q042-Category-select | T040-Category | category-id | ||
| button ButtonDetails |
connects to F041-Categories-detail |
CategoryId *) |
*) Public variable
Change history
| date | version | change |
| jan2016 | A5.4 | review and update |
| oct2002 | A4.1 | Ariadne 4.1, text converted to html |