Data Types

  Previous topic Next topic JavaScript is required for the print function  

Columns can store many different types of data, but each individual column may hold only one type. When a column is defined, its data type is specified. This enables it to efficiently store that type of data. For example, to store a number from 0 to 100, using a column defined as a single BYTE takes less space than one defined as a decimal number column (a byte can hold an unsigned whole number between 0 and 255).


Data Types Used in TelcoMgr


Byte : A numeric constant. If omitted, the initial value is zero, unless the AUTO attribute is present.

Date : DATE declares a four-byte date variable. A DATE used in a numeric expression is converted to the number of days elapsed since December 28, 1800. The valid Standard Date range is January 1, 1801 through December 31, 9999. Using an out-of-range date produces unpredictable results.

Decimal : A required numeric constant containing the total number of decimal digits (integer and fractional portion combined) in the variable. The maximum length is 31. Example = 10,000.50

Long : LONG declares a four-byte signed integer, using the Intel 8086 long integer format. The high-order bit is the sign bit (0 = positive, 1 = negative). Negative values are represented in standard two's complement notation.

Memo : Memo fields are large String fields used for alpha and/or numeric character or binary data elements.

String : STRING declares a fixed-length alpha and/or numeric character string. The memory assigned to the STRING is initialized to all blanks unless the AUTO attribute is present.


Format Examples and Pictures:


STRING(40) indicates a STRING field with 40 characters;

DECIMAL(9,2) indicates a DECIMAL field with 9 characters, 2 are to the right of the decimal, with attributes (minus, comma, period, currency symbol); 99,900.99;

LONG(-14) indicates a numeric field with 14 characters with a minus attribute.


Page url: