Configuration: FoxPro Index Fields
Index fields may be one of the following types used
by the FoxPro system:
-
Character – Use character fields for
letters, numbers, and symbols (ex. Social Security numbers, zip
codes, phone numbers, client reference numbers). A maximum field
width of 254 spaces is available.
-
Numeric – Holds numbers only. A field width
of up to 20 with an optional plus/minus sign and decimal place is
available.
-
Date – FoxPro can understand and perform
mathematical calculations on date values and return the result as a
date. FoxPro can also display the date in any of a number of U.S.
and international formats.
-
Logical – Holds T (true) or F (false).
NOTE: The type is
determined by the default value assigned for that field.
The field name can be up to eight characters with
no spaces. It can start with letters or the underscore symbol (_)
and contains only letters, numbers, and underscores.
The following seven field names are reserved and
cannot be used for index information:
volume npath nfile nfext npages status
nfullname
Related Topics
Image Database
Configuration Introduction
|