The information in this article applies to:
SUMMARYBelow is a list of the system capacities for FoxPro for Windows.
MORE INFORMATIONSome 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 FilesMaximum # 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 CharacteristicsMaximum 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 ArraysDefault # 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 FilesMaximum # 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 CapacitiesMaximum # of objects in a report definition Unlimited (2) Maximum # of lines in a report definition 255 Maximum # of grouping levels 20 Miscellaneous CapacitiesMaximum # 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 SupportNumber 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 : |
Last Reviewed: August 20, 1999 |