System Capacities for FoxPro 2.5 for MS-DOS

ID: Q106269

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, and 2.5b

SUMMARY

Below is a list of the system capacities for FoxPro for MS-DOS.

MORE INFORMATION

Some capacities may be limited by available memory. A "(1)" indicates that the actual file size (in bytes) cannot exceed 2 gigabytes (GB) for single user or exclusively opened multiuser .DBF files. Shared multiuser .DBF files with no indexes or .IDX indexes cannot exceed 1 GB. Shared multiuser .DBF files with structural .CDX indexes cannot exceed 2 GB. A "(2)" indicates that the capacity is limited by memory and available file handles. .CDX files use only one file handle. Lastly, a "(3)" means a program module is one procedure. A program or application can contain an unlimited number of program modules.

Tables and Index Files                         FoxPro        FoxPro
                                                             Extended

Maximum # of records per database file         1 billion     1 billion
                                                  (1)           (1)
Maximum # of characters per record             65,500        65,500
Maximum # of fields per record                    255           255
Maximum # of databases open at one time            25           255
Maximum # of characters per database field        254           254
Maximum # of characters per index key (.IDX)      100           100
Maximum # of characters per index key (.CDX)      240           240
Maximum # of open index files per table        Unlimited     Unlimited
                                                  (2)           (2)
Maximum # of open indexes in all work areas    Unlimited     Unlimited
                                                  (2)           (2)
Maximum # of relations                         Unlimited     Unlimited
Maximum length of relational expressions       Unlimited     Unlimited

Field Characteristics

Maximum size of character fields                  254           254
Maximum size of numeric (and float) fields         20            20
Maximum number of characters in field names        10            10
Digits of precision in numeric computations        16            16

Memory Variables and Arrays

Default # of memory variables                     256           256
Maximum # of memory variables                   3,600        65,000
Maximum # of arrays                             3,600        65,000
Maximum # of elements per array                 3,600        65,000

Program and Procedure Files

Maximum # of lines in source program files     Unlimited     Unlimited
Maximum size of compiled program modules        64K (3)       64K (3)
Maximum # of procedures per file               Unlimited     Unlimited
Maximum # of nested DO calls                       32            32
Maximum # of READ nesting levels                    5             5

Maximum # of nested structured programming

commands                                           64            64
Maximum # of procedure arguments                   24            24

Report Writer Capacities

Maximum # of objects in a report definition    Unlimited     Unlimited
Maximum # of lines in a report definition         255           255
Maximum # of grouping levels                       20            20

Window Support

Maximum # of open windows (all types)          Unlimited     Unlimited
                                                  (2)           (2)
Maximum # of open Browse windows                   25            25

Miscellaneous Capacities

Maximum # of characters per character string      64K          2 GB
Maximum # of characters per command line        2,048         2,048
Maximum # of characters per macro subst. line   2,048         2,048
Maximum # of open files                            99      MS-DOS limit
Maximum keystrokes in keyboard macro            1,024         1,024

Maximum fields that can be selected by a SQL

SELECT statement                                  255           255

Color Support

Number of color schemes per color set              24            24
Maximum # of color sets (in FOXUSER file)      Unlimited     Unlimited
Number of colors per color scheme                  10            10
Schemes available for user definition               8             8

REFERENCE

FoxPro for MS-DOS, "Update," version 2.5, pages 4-4 through 4-5

Additional reference words: FoxDos 2.50 2.50a 2.50b KBCategory: kbprg KBSubcategory:

Last Reviewed: April 18, 1995