Ariadne - Technical description
A060 |
Categories |
Description
Adding, deleting, updating category data
Remark: The boundaries of age classes in T044-Age-class are expressed in ages (e.g. junior A is 17-18 years). These bondaries are translated to birth years, relative to the current year: birth year = current year - age boundary. Example: someone is assigned to the age class of seniors, when he/she becomes 19 years the current year. if the current year is 2001, then the lower boundary for the senior class, expressed in birth years is 2001 - 19 = 1982.
Access path
 F000-Menu |
|
 F040-Categories |
A060 |
| F041-Categories-detail |
A061 |
| F042-Startinterval |
|
| F010-Remark |
screen shot: F040-Categories
Function structure
| Form | Control | Subform | Query | Table | Attribute |
| F040-Categories | Q040-Categories | T040-Categories | |||
| Listbox CurrentCompetition |
Q100-Current-competition | T100-Current-competition | |||
| dropbox CUType |
T031-CU-type | CU-type-id | |||
| dropbox Boat-type |
T032-Boat-type | boat-type-id | |||
| dropbox gender |
T033-Gender | gender-id | |||
| dropbox age-class |
Q044-Ageclass | T044-Age-class | age-class-id | ||
| Button ButtonDetails |
F041-Categories-detail | CategoryId *) | |||
| Button ButtonClose |
*) navigating between forms with the public variable CategoryId
| Form | Control | Subform | Query | Table | Attribute |
| F041-Categories-detail | Q041-Categories-detail | T040-Categories | |||
| dropbox CUType |
T031-CU-type | CU-type-id | |||
| dropbox Boat-type |
T032-Boat-type | boat-type-id | |||
| dropbox gender |
T033-Gender | gender-id | |||
| dropbox age-class |
Q044-Ageclass | T044-Age-class | age-class-id | ||
| subform Startinterval |
F042-Startinterval | category-id | |||
| BirthYearMin | =[age-class].[Column](3) | ||||
| BirthYearMax | =[age-class].[Column](4) | ||||
| subform Remark |
F010-Remark | remark-id *) | |||
| Button ButtonClose |
*)Remark-id = category-id prefixed with "C".
| Form | Control | Subform | Query | Table | Attribute |
| F042-Startinterval | Q085-Category StartintervalHistory | T040-Category T800-Archived-competition T880-Start-interval |
T040-Categories |
Change history
| date | Ariadne version | change |
| 01-10-02 | 4.1.0 | Text converted to html |