IntelliTrack Stockroom Inventory User Manual

Page 338

Advertising
background image

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

Advertising