Microsoft KB Archive/106269

{| = System Capacities for FoxPro 2.5 for MS-DOS =
 * width="100%"|

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:
 * }