Microsoft KB Archive/106269: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 15: | Line 15: | ||
== MORE INFORMATION == | == MORE INFORMATION == | ||
Some capacities may be limited by available memory. A | 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. | ||
<pre>Tables and Index Files FoxPro FoxPro | <pre>Tables and Index Files FoxPro FoxPro | ||
Line 90: | Line 90: | ||
== REFERENCE == | == REFERENCE == | ||
FoxPro for MS-DOS, | FoxPro for MS-DOS, "Update," version 2.5, pages 4-4 through 4-5 | ||
Additional reference words: FoxDos 2.50 2.50a 2.50b KBCategory: kbprg KBSubcategory: | Additional reference words: FoxDos 2.50 2.50a 2.50b KBCategory: kbprg KBSubcategory: |
Latest revision as of 10:00, 20 July 2020
System Capacities for FoxPro 2.5 for MS-DOSID: Q106269 The information in this article applies to:
SUMMARYBelow is a list of the system capacities for FoxPro for MS-DOS. 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 Files FoxPro FoxPro Extended Maximum # of records per database file 1 billion 1 billion (1) (1) Maximum # of characters per record 65,500 65,500 Maximum # of fields per record 255 255 Maximum # of databases open at one time 25 255 Maximum # of characters per database field 254 254 Maximum # of characters per index key (.IDX) 100 100 Maximum # of characters per index key (.CDX) 240 240 Maximum # of open index files per table Unlimited Unlimited (2) (2) Maximum # of open indexes in all work areas Unlimited Unlimited (2) (2) Maximum # of relations Unlimited Unlimited Maximum length of relational expressions Unlimited Unlimited Field CharacteristicsMaximum size of character fields 254 254 Maximum size of numeric (and float) fields 20 20 Maximum number of characters in field names 10 10 Digits of precision in numeric computations 16 16 Memory Variables and ArraysDefault # of memory variables 256 256 Maximum # of memory variables 3,600 65,000 Maximum # of arrays 3,600 65,000 Maximum # of elements per array 3,600 65,000 Program and Procedure FilesMaximum # of lines in source program files Unlimited Unlimited Maximum size of compiled program modules 64K (3) 64K (3) Maximum # of procedures per file Unlimited Unlimited Maximum # of nested DO calls 32 32 Maximum # of READ nesting levels 5 5 Maximum # of nested structured programming commands 64 64 Maximum # of procedure arguments 24 24 Report Writer CapacitiesMaximum # of objects in a report definition Unlimited Unlimited Maximum # of lines in a report definition 255 255 Maximum # of grouping levels 20 20 Window SupportMaximum # of open windows (all types) Unlimited Unlimited (2) (2) Maximum # of open Browse windows 25 25 Miscellaneous CapacitiesMaximum # of characters per character string 64K 2 GB Maximum # of characters per command line 2,048 2,048 Maximum # of characters per macro subst. line 2,048 2,048 Maximum # of open files 99 MS-DOS limit Maximum keystrokes in keyboard macro 1,024 1,024 Maximum fields that can be selected by a SQL SELECT statement 255 255 Color SupportNumber of color schemes per color set 24 24 Maximum # of color sets (in FOXUSER file) Unlimited Unlimited Number of colors per color scheme 10 10 Schemes available for user definition 8 8 REFERENCEFoxPro for MS-DOS, "Update," version 2.5, pages 4-4 through 4-5 Additional reference words: FoxDos 2.50 2.50a 2.50b KBCategory: kbprg KBSubcategory: |
Last Reviewed: April 18, 1995 |