Class FieldDataType
Datatype of the field in the database
Namespace: SuperOffice.Data
Assembly: SoCore.dll
Syntax
public sealed class FieldDataType : Enum
Fields
dbBlob
11: Blob in hte database
Declaration
public const FieldDataType dbBlob
Field Value
Type | Description |
---|---|
FieldDataType |
dbDateLocal
17: Date, stored as a datetime in the database, with time value that should be ignored. This time is not timezone converted/sensitive
Declaration
public const FieldDataType dbDateLocal
Field Value
Type | Description |
---|---|
FieldDataType |
dbDateTimeLocal
6: DateTime ( e.g. seconds since 01.01.1970) in Local time stored as an integer value in the database.
Declaration
public const FieldDataType dbDateTimeLocal
Field Value
Type | Description |
---|---|
FieldDataType |
dbDateTimeUTC
2: DateTime ( e.g. seconds since 01.01.1970) in UTC stored as an integer value in the database.
Declaration
public const FieldDataType dbDateTimeUTC
Field Value
Type | Description |
---|---|
FieldDataType |
dbDouble
3: Double precision real (e.g. System.Double) value.
Declaration
public const FieldDataType dbDouble
Field Value
Type | Description |
---|---|
FieldDataType |
dbExtendedDateTimeLocal
14: DateTime, stored as a real datetime in the database, with extended range. Local time zone
Declaration
public const FieldDataType dbExtendedDateTimeLocal
Field Value
Type | Description |
---|---|
FieldDataType |
dbExtendedDateTimeUTC
15: DateTime, stored as a real datetime in the database, with extended range. UTC time
Declaration
public const FieldDataType dbExtendedDateTimeUTC
Field Value
Type | Description |
---|---|
FieldDataType |
dbInt
4: Integer (e.g. System.Int32) value.
Declaration
public const FieldDataType dbInt
Field Value
Type | Description |
---|---|
FieldDataType |
dbIntId
5: Integer (e.g. System.Int32) id.
Declaration
public const FieldDataType dbIntId
Field Value
Type | Description |
---|---|
FieldDataType |
dbIntIdArr
18: Array if int's that represent ID's (foreign keys). Stored encoded as a long string, with each int becoming a word that can be fulltext indexed
Declaration
public const FieldDataType dbIntIdArr
Field Value
Type | Description |
---|---|
FieldDataType |
dbNull
9: This is not a value
Declaration
public const FieldDataType dbNull
Field Value
Type | Description |
---|---|
FieldDataType |
dbShort
8: Short integer (e.g. System.Int16) value
Declaration
public const FieldDataType dbShort
Field Value
Type | Description |
---|---|
FieldDataType |
dbShortId
1: Short integer (e.g. System.Int16) id.
Declaration
public const FieldDataType dbShortId
Field Value
Type | Description |
---|---|
FieldDataType |
dbString
13: String (e.g. System.String) preferebly stored as a variable lenght string in the database. The Length can be up to (e.g. not including) 256 characters long depending upon the datatype.
Declaration
public const FieldDataType dbString
Field Value
Type | Description |
---|---|
FieldDataType |
dbStringBlob
12: Long string (e.g. System.String) stored as a (text) blob in the database
Declaration
public const FieldDataType dbStringBlob
Field Value
Type | Description |
---|---|
FieldDataType |
dbTimeLocal
16: Time, stored as a datetime in the database, with date value that should be ignored. This time is not timezone converted/sensitive
Declaration
public const FieldDataType dbTimeLocal
Field Value
Type | Description |
---|---|
FieldDataType |
dbUInt
10: Unsigned integer (e.g. System.UInt32) id
Declaration
public const FieldDataType dbUInt
Field Value
Type | Description |
---|---|
FieldDataType |
dbUShort
7: Unsigned short integer (e.g. System.UInt16) value
Declaration
public const FieldDataType dbUShort
Field Value
Type | Description |
---|---|
FieldDataType |
Undefined
0: Undefined data type (error)
Declaration
public const FieldDataType Undefined
Field Value
Type | Description |
---|---|
FieldDataType |
value__
Datatype of the field in the database
Declaration
public int value__
Field Value
Type | Description |
---|---|
Int32 |