PRB: System Capacities for FoxPro Ver 2.5b for Macintosh

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

   handles.

   contain an unlimited number of program modules.

   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