FIELD data type

User avatar
sal21
PlatinumLounger
Posts: 4343
Joined: 26 Apr 2010, 17:36

FIELD data type

Post by sal21 »

are only this Type of field?

Code: Select all

Private Function LEGGI_TIPO_FIELD(ByVal v_lngValue As Long) As String

    Select Case v_lngValue

    Case 2
        GetDataType = "Integer Short"

    Case 3
        GetDataType = "Long"

    Case 4
        GetDataType = "Single"

    Case 5
        GetDataType = "Double"

    Case 6
        GetDataType = "Currency"

    Case 7
        GetDataType = "Date DateTime"

    Case 11
        GetDataType = "Boolean Bit"

    Case 17
        GetDataType = "Boolean Byte"

    Case 72
        GetDataType = "GUID"

    Case 128

        GetDataType = "Long LongBinary"

    Case 129
        GetDataType = "String Text"

    Case 202
        GetDataType = "Text"

    End Select

End Function


User avatar
HansV
Administrator
Posts: 78390
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: FIELD data type

Post by HansV »

Best wishes,
Hans