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 property of the object.

Inheritance

Object

DictionaryConstants.ConceptualFieldType

Namespace: SuperOffice.Data

Assembly: SoCore.dll

Syntax

public static class ConceptualFieldType : Object

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
Int32

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 property of the object.

Declaration

public const int Bool = 8

Field Value

Type	Description
Int32

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 property of the object.

Declaration

public const int Byte = 3

Field Value

Type	Description
Int32

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 property of the object.

Declaration

public const int ByteId = 4

Field Value

Type	Description
Int32

Char

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

Declaration

public const int Char = -1

Field Value

Type	Description
Int32

Date

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

Declaration

public const int Date = 13

Field Value

Type	Description
Int32

DateTime

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

Declaration

public const int DateTime = 12

Field Value

Type	Description
Int32

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
Int32

Double

16: Floating-point value

Declaration

public const int Double = 16

Field Value

Type	Description
Int32

Float

16: Floating-point value

Declaration

public const int Float = 16

Field Value

Type	Description
Int32

Long

9: Signed 32-bit integer

Declaration

public const int Long = 9

Field Value

Type	Description
Int32

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
Int32

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
Int32

Short

5: 16-bit signed integer

Declaration

public const int Short = 5

Field Value

Type	Description
Int32

ShortId

7: 16-bit unsigned integer

Declaration

public const int ShortId = 7

Field Value

Type	Description
Int32

String

17: String (usually max 254 significant characters)

Declaration

public const int String = 17

Field Value

Type	Description
Int32

TextBlob

22: Text large object

Declaration

public const int TextBlob = 22

Field Value

Type	Description
Int32

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 property of the object.

Declaration

public const int Time = 14

Field Value

Type	Description
Int32

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 property of the object.

Declaration

public const int UChar = 2

Field Value

Type	Description
Int32

ULong

10: Unsigned 32-bit integer

Declaration

public const int ULong = 10

Field Value

Type	Description
Int32

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
Int32

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 property of the object.

Declaration

public const int Void = 0

Field Value

Type	Description
Int32

VString

18: String, usually max 1023 or 2047 characters

Declaration

public const int VString = 18

Field Value

Type	Description
Int32