IntelliTrack Check In/Out - Manual (Page 434)

I NTELLI T RACK C HECK I N -O UT V 8.1
User Manual
404
TABLE 16. Data Type Settings
Field Type Size Settings
Field Types Size Settings
Text (Default) Text up to 255 characters or the length set by
the FieldSize property, whichever is less.
Memo Text with a maximum length of 64,000 bytes. Memo
fields can't be indexed.
Number Any numeric type. See the FieldSize property for more
information.
Date/Time Date and time values for years from 100 to 9999.
Currency Accurate to 15 digits on the left side of the decimal
point and 4 digits on the right.
Counter A number automatically incremented whenever a new
record is added to a table. Counter fields can't be
updated.
Yes/No Yes and No values and fields that contain only one of
two values. Yes/No fields can't be indexed.
OLE Object An object such as a Microsoft Excel spreadsheet or a
Microsoft Draw graphic that is created by an object
application. The maximum size is about 1 gigabyte.
OLE Object fields can't be indexed.
TABLE 17. Numeric Fields Size Settings
Field Type Size Settings
Byte Stores numbers from 0 to 255 (no fractions). It occu-
pies 1 byte.
Integer Stores numbers from -32,768 to 32,767 (no fractions).
It occupies 2 bytes.
Long Integer Stores numbers from -2,147,483,648 to 2,147,483,647
(no fractions). It occupies 4bytes.
Single Stores numbers with six digits of precision, from -
3.402823E38 to 3.402823E38. It occupies 4 bytes.
Double (Default) Stores numbers with 10 digits of precision,
from -.79769313486232E308 to
1.79769313486232E308. It occupies 8 bytes.
2283.book Page 404 Thursday, July 7, 2011 2:29 PM