IntelliTrack Stockroom Inventory - Manual (Page 338)

I NTELLI T RACK S TOCKROOM V 7.0
User Manual
310
TABLE 15. Data Type 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 16. Numeric Field Size Settings
Field Types Size Settings
Byte Stores numbers from 0 to 255 (no fractions). It occupies 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 occu-
pies 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.
2289.book Page 310 Thursday, July 9, 2009 2:35 PM