In the MSAccess file (the logbook itself), I can find "Water", "Surface", "Buddy", "Entrey", "Tanktype" and "DiveType".
For some reason, there are some of them only ith a label, other with an ID and some with both.
For instance :
Both : Buddy...
Label only: UWCurrent, Weather, Surface...
ID only: Water, DiveType, TankType, Visibility...
For DiveType, there is another table with mapping table between ID and label. But for Water of TankType, it's not the case.
Is there some place where I can find the meaning of numbers (ID) for the "ID only" fields, especially Water, EntryType and TankType, but other ones also.
Thank you.
Enumeration values
-
- Posts: 18
- Joined: Fri Jan 19, 2018 21:14
- Location: Toulon / France
- Contact:
Enumeration values
https://fr.divelogs.de/timeline/EricKlasen
Re: Enumeration values
Hi
Country, City, Place, Buddy: Those are special fields with both, label and optional an ID if it's linked to a detailed entry, which is explained in more detail here.
ID only fields (e.g. Water, Entry): It's the zero based list item in the dropdown lists of the logbook window, so first item=0, 2nd item=1 etc. Those lists are fixed, so the user cannot add new items here.
You can find out the meaning either by looking into the logbook window dropdowns and count or you can have a look in the logbook table window. In view mode you can see the label, e.g. "Saltwater", but if you switch to edit mode, you see the numeric value from the database.
Let me know if you need more information. Here is a quick overview:
Country, City, Place, Buddy: Those are special fields with both, label and optional an ID if it's linked to a detailed entry, which is explained in more detail here.
ID only fields (e.g. Water, Entry): It's the zero based list item in the dropdown lists of the logbook window, so first item=0, 2nd item=1 etc. Those lists are fixed, so the user cannot add new items here.
You can find out the meaning either by looking into the logbook window dropdowns and count or you can have a look in the logbook table window. In view mode you can see the label, e.g. "Saltwater", but if you switch to edit mode, you see the numeric value from the database.
Let me know if you need more information. Here is a quick overview:
Code: Select all
Public Enum eWaterType
Unknown = 0
Salt = 1
Fresh = 2
Brackish = 3
Chlorinated = 4
End Enum
Public Enum eEntryType
Unknown = 0
Shore = 1
Boat = 2
Pool = 3
Aquarium = 4
Jetty = 5
Ice = 6
End Enum
Public Enum eVisibility
Unknown = 0
Good = 1
Average = 2
Bad = 3
End Enum
Public Enum eTankType
Unknown = 0
Alu = 1
Steel = 2
Carbon = 3
End Enum
Public Enum eSupplyType
OC = 0
SCR = 1
CCR = 2
PSCR = 3
Sidemount = 4
Surface = 5
End Enum
-
- Posts: 18
- Joined: Fri Jan 19, 2018 21:14
- Location: Toulon / France
- Contact:
Re: Enumeration values
Thanks. I used the list you proposed. I just haven't took the time to thank you earlier, shame on me.
https://fr.divelogs.de/timeline/EricKlasen