|
|
|
The following field types are available for the Table Designer, Form Designer Memory Table Designer, Memory Table Builder and the MemoryTableBuilder object:
Type |
Description |
Maximum size |
String |
A string of characters consisting of letters and numbers. |
each character = 1 byte |
Byte |
A cardinal number between 0 and 255. |
8 bits |
Word |
A cardinal number between 0 and 65535. |
2 bytes |
Smallint |
A signed cardinal number between -32768 and 32767. |
2 bytes |
Integer |
A signed cardinal number between -2,147,483,648 and 2,147,483,647. Integer fields with names ending in ID are implicitly RowID fields. |
4 bytes |
Float |
A floating point number between -10308 and 10308. Use to store very large or very small values. |
8 bytes |
Boolean |
A True or False condition. |
1 byte |
Date |
A date. Dates can be formatted. For example: tblMem1.Fields.Item("Date").Format = "YYYY-MM-DD" |
4 bytes |
Time |
A time between 00:00:00 and 23:59:59. |
4 bytes |
DateTime |
A date and time. |
8 bytes |
AutoInc |
An Integer field that adds 1 to the previous number. Usually used to store document numbers to uniquely identify each record. If a previous number is deleted, it is not re-used. Each table can only have one AutoInc field. |
4 bytes |
Largeint |
A signed cardinal number between -9,223,372,036,854,775,807 (-263+1) and 9,223,372,036,854,775,807 (263-1). |
8 bytes |
Variant |
One of the above data types. Specify the maximum size in the Size field. |
each character = 1 byte |
RowID |
A stored AutoInc value from another table (for example, a parent table). RowID fields may not contain negative numbers, as these are reserved for surrogate IDs as part of Transaction processing. |
4 bytes |
Tinyint |
A signed cardinal number between -128 and 127. |
1 byte |
UString |
A Unicode string of characters. |
each character 2 to 4 bytes. |
|
|
|
