Enumeration values

Discussions about Diving Log 6.0 - questions and hints
Post Reply
WileCoyote
Posts: 18
Joined: Fri Jan 19, 2018 21:14
Location: Toulon / France
Contact:

Enumeration values

Post by WileCoyote »

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.
https://fr.divelogs.de/timeline/EricKlasen
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Enumeration values

Post by divinglog »

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:

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
WileCoyote
Posts: 18
Joined: Fri Jan 19, 2018 21:14
Location: Toulon / France
Contact:

Re: Enumeration values

Post by WileCoyote »

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
Post Reply