Class FieldDataType
Datatype of the field in the database
Namespace: SuperOffice.Data
Assembly: SoCore.dll
Syntax
public sealed class FieldDataType : EnumFields
dbBlob
11: Blob in hte database
Declaration
public const FieldDataType dbBlobField 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 dbDateLocalField 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 dbDateTimeLocalField 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 dbDateTimeUTCField Value
| Type | Description |
|---|---|
| FieldDataType |
dbDouble
3: Double precision real (e.g. System.Double) value.
Declaration
public const FieldDataType dbDoubleField 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 dbExtendedDateTimeLocalField Value
| Type | Description |
|---|---|
| FieldDataType |
dbExtendedDateTimeUTC
15: DateTime, stored as a real datetime in the database, with extended range. UTC time
Declaration
public const FieldDataType dbExtendedDateTimeUTCField Value
| Type | Description |
|---|---|
| FieldDataType |
dbInt
4: Integer (e.g. System.Int32) value.
Declaration
public const FieldDataType dbIntField Value
| Type | Description |
|---|---|
| FieldDataType |
dbIntId
5: Integer (e.g. System.Int32) id.
Declaration
public const FieldDataType dbIntIdField 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 dbIntIdArrField Value
| Type | Description |
|---|---|
| FieldDataType |
dbNull
9: This is not a value
Declaration
public const FieldDataType dbNullField Value
| Type | Description |
|---|---|
| FieldDataType |
dbShort
8: Short integer (e.g. System.Int16) value
Declaration
public const FieldDataType dbShortField Value
| Type | Description |
|---|---|
| FieldDataType |
dbShortId
1: Short integer (e.g. System.Int16) id.
Declaration
public const FieldDataType dbShortIdField 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 dbStringField Value
| Type | Description |
|---|---|
| FieldDataType |
dbStringBlob
12: Long string (e.g. System.String) stored as a (text) blob in the database
Declaration
public const FieldDataType dbStringBlobField 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 dbTimeLocalField Value
| Type | Description |
|---|---|
| FieldDataType |
dbUInt
10: Unsigned integer (e.g. System.UInt32) id
Declaration
public const FieldDataType dbUIntField Value
| Type | Description |
|---|---|
| FieldDataType |
dbUShort
7: Unsigned short integer (e.g. System.UInt16) value
Declaration
public const FieldDataType dbUShortField Value
| Type | Description |
|---|---|
| FieldDataType |
Undefined
0: Undefined data type (error)
Declaration
public const FieldDataType UndefinedField Value
| Type | Description |
|---|---|
| FieldDataType |
value__
Datatype of the field in the database
Declaration
public int value__Field Value
| Type | Description |
|---|---|
| Int32 |