Ariadne - Technical description
A210 |
Events |
Description
Adding, updating and deleting of events in a program block, determining of the event order, assigning categories to events, splitting or joining events.
The table relation between T400-Event and T450-Category-in-event is set to 'check referential integrity' and 'cascading update'. This means that whe an event 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 event number sub is added. With this sub it is possible to split events, while the parts can be kept together in the same progam block. E.g. an event 23 can be split in 23 and 23a.
Access path
 F000-Menu |
|
 F400-Events |
|
| F410-Event-details |
|
|
Function structure
Sorting order is: program block, event number
| Form | Control | Subform | Query | Table | Attribute |
| F400-Events | Q400-Events | T110-Program-block T400-Event |
|||
| 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-event | T400-Event T450-Category-in-event T500-Competing-unit |
event-id | ||
| button Details |
connects to F410-Event-details |
EventId *) | |||
| button Entries |
connects to F506-Entries-per-event |
EventId *) | |||
| button ButtonResort |
requeries Q400 | ||||
| button ButtonClose |
*) Public variable
| Form | Control | Subform | Query | Table | Attribute |
| F410-Event-details | Q410-Event-details | T400-Event | |||
| listbox CurrentCompetition |
Q100-Current-competiton | T100-Current-competition | |||
| dropbox EventSelect |
Q412-Event-select | T400-Event | event-id | ||
| subform EventCategories |
F412-Category-in-event | event-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-event | Q450-Category-in-event | T400-Event T450-Category-in-event |
event-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 |
| 24-10-02 | 1.5 | Ariadne 4.1, text converted to html |