Microsoft KB Archive/113520

{| = PRB: System Capacities for FoxPro Ver 2.5b for Macintosh =
 * width="100%"|

ID: Q113520

The information in this article applies to:


 * Microsoft FoxPro for Macintosh, version 2.5b

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

NOTE: Some capacities may be limited by available memory.

(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. (2) Indicates that the capacity is limited by memory and available file handles. (3) Means a program module is one procedure. A program or application can contain an unlimited number of program modules. (4) Indicates that FoxPro for Macintosh ignores commands that save and call color sets. Color schemes should be used instead. For more information about how FoxPro for Macintosh uses color sets, refer to the "FoxPro  ReadMe" file.

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                                   1024 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 records per table file                    1 billion (1) Maximum # of open windows (all types)                  Unlimited (2) Maximum # of open Browse windows                                 225 Maximum # of characters per character string             8 gigabytes Maximum # of characters per command line                       2,048 Maximum # of characters per macro substitution line            2,048 Maximum # of open files                       Operating system limit Maximum keystrokes in keyboard macro                            1024 Maximum fields that can be selected by an SQL-SELECT statement   255

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

REFERENCE
"Developer's Guide," pages 404-405

Additional reference words: FoxMac 2.50b KBCategory: kbprg kbprb KBSubcategory:
 * }