Class DictionaryConstants.ConceptualFieldType

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Inheritance

object

DictionaryConstants.ConceptualFieldType

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.Data

Assembly: SoCore.dll

Syntax

public static class DictionaryConstants.ConceptualFieldType

Fields

Blob

20: Binary large object; only one such field is allowed per table in the current C++ SODBIF implementation.

Declaration

public const int Blob = 20

Field Value

Type	Description
int

Bool

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int Bool = 8

Field Value

Type	Description
int

Byte

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int Byte = 3

Field Value

Type	Description
int

ByteId

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int ByteId = 4

Field Value

Type	Description
int

Char

-1: Char, not a datatype we use at all in the database

Declaration

public const int Char = -1

Field Value

Type	Description
int

Date

13: Date, without a time component; not used in practice

Declaration

public const int Date = 13

Field Value

Type	Description
int

DateTime

12: DateTime, expressed as seconds since 00:00:00 january 1st, 1970

Declaration

public const int DateTime = 12

Field Value

Type	Description
int

DbDateTime

21: Datetime, stored as such in the database (not stored as seconds since 1/1/1970!)

Declaration

public const int DbDateTime = 21

Field Value

Type	Description
int

Double

16: Floating-point value

Declaration

public const int Double = 16

Field Value

Type	Description
int

Float

16: Floating-point value

Declaration

public const int Float = 16

Field Value

Type	Description
int

Long

9: Signed 32-bit integer

Declaration

public const int Long = 9

Field Value

Type	Description
int

LongId

11: Record ID, in principle unsigned 32-bit integer, the 'int' datatype is used in NetServer

Declaration

public const int LongId = 11

Field Value

Type	Description
int

LvString

18: Long string, typically 1023 or 2047 characters long, usually stored as a blob

Declaration

public const int LvString = 18

Field Value

Type	Description
int

Short

5: 16-bit signed integer

Declaration

public const int Short = 5

Field Value

Type	Description
int

ShortId

7: 16-bit unsigned integer

Declaration

public const int ShortId = 7

Field Value

Type	Description
int

String

17: String (usually max 254 significant characters)

Declaration

public const int String = 17

Field Value

Type	Description
int

TextBlob

22: Text large object

Declaration

public const int TextBlob = 22

Field Value

Type	Description
int

Time

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int Time = 14

Field Value

Type	Description
int

UChar

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int UChar = 2

Field Value

Type	Description
int

ULong

10: Unsigned 32-bit integer

Declaration

public const int ULong = 10

Field Value

Type	Description
int

UShort

6: Unsigned 16-bit integer; also used for flags that express a boolean value (0, 1 allowed)

Declaration

public const int UShort = 6

Field Value

Type	Description
int

VString

18: String, usually max 1023 or 2047 characters

Declaration

public const int VString = 18

Field Value

Type	Description
int

Void

Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.

These constants should be used to interpret the SuperOffice.Data.Dictionary.SoField.ConceptualType property of the SuperOffice.Data.Dictionary.SoField object.

Declaration

public const int Void = 0

Field Value

Type	Description
int