# 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 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.