Progress
Language Tutorial
for Character


Defining Fields

A field is a particular item of information that helps describe the subject of a table. For example, the name of a customer, the address, and the credit limit are information items that help define a customer. As an example of field properties, access the Cust-Num field by choosing Modify from the Field Editor and then choosing the field.

This is shown in Figure 4–3.

Figure 4–3: Field Editor

Two properties make up the essential definition of a field object: the field name and the data type.

Table 4–3 describes the Progress data types.

Table 4–3: Data Types
Data Type
Description
CHARACTER
Character fields contain any type of data (letters, numbers, and special characters). Some character fields in the Customer table are Name, Address, and Phone.
INTEGER
Integer fields contain whole numbers. They can be positive or negative, from roughly -2 billion to 2 billion. The Cust-Num field from the Customer table is an integer field.
DECIMAL
Decimal fields hold decimal numbers up to 50 digits in length, including up to 10 digits to the right of the decimal. The Balance field in the Customer table is a decimal field.
DATE
Date fields contain dates. The Invoice-Date field in the Invoice table is a date field.
LOGICAL
Logical fields contain values that evaluate to YES/NO or TRUE/FALSE. The Backorder field of the Order-Line table is a LOGICAL field.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095