Name
|
Native Type
|
Description
|
String
|
String
|
Ansi string up 255 characters
|
SmallInt
|
SmallInt
|
2 byte integral number
|
Float
|
Float
|
8 byte floating point number
|
Byte
|
Byte
|
1 byte positiv integral number
|
Boolean
|
Boolean
|
True or false
|
Date
|
Date
|
Date
|
Memo
|
Memo
|
Ansi string of arbitrary length
|
Enum
|
Enum
|
One out of a list of available values
|
AutoInc
|
AutoInc
|
Automatically assigned unique integer
|
Link
|
Link
|
One-to-many relationship to another table
|
Blob
|
Blob
|
Binary data of arbitrary size
|
Relation
|
Relation
|
Many-to-many relationsship to another table
|
Time
|
Time
|
Time of day in hours and minutes
|
Integer
|
Integer
|
4 byte integral number
|
DateTime
|
DateTime
|
Date and time down to and including millisecons
|
WideString
|
WideString
|
Unicode string up to 127 characters
|
WideMemo
|
WideMemo
|
Unicode string of arbitrary length
|
LargeInt
|
LargeInt
|
8 byte integral number
|