Microsoft KB Archive/106268

{|
 * width="100%"|

-

The information in this article applies to:


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

-

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

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
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

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