Microsoft KB Archive/106268

From BetaArchive Wiki

System Capacities for FoxPro 2.5 for Windows

ID: Q106268

The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b


Below is a list of the system capacities for FoxPro for Windows.


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

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

Field Characteristics

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

Memory Variables and Arrays

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

Program and Procedure Files

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

Report Writer Capacities

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

Miscellaneous Capacities

Maximum # of open windows (all types)                Unlimited (2)
Maximum # of open Browse windows                     255
Maximum # of characters per character string         2 gigabytes
Maximum # of characters per command line             2,048
Maximum # of characters per macro subst. line        2,048
Maximum # of open files                              DOS limit
Maximum keystrokes in keyboard macro                 1024
Maximum fields that can be selected by a SQL
SELECT statement                                     255 

Color Support

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


"Developer's Guide," pages A-4 through A-5 Additional query words: FoxWin 2.50

Keywords          : FxprgMultiuser 
Version           : 2.50 2.50a 2.50b
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: August 20, 1999
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.