Microsoft KB Archive/113441

= FoxPro for Windows & MS-DOS Specifications & Limitations =

Article ID: 113441

Article Last Modified on 10/29/2003

-

APPLIES TO


 * Microsoft Visual Basic 3.0 Professional Edition
 * Microsoft Visual Basic 3.0 Professional Edition

-



This article was previously published under Q113441



SUMMARY
This article lists some of the Microsoft FoxPro version 2.5 for Windows and MS-DOS specifications and limitations. This data was compiled from Appendix A of the Microsoft FoxPro for Windows Developer's Guide and Chapter four of the Microsoft FoxPro for MS-DOS Update manual.

It is provided here for the benefit of Visual Basic programmers.



Table & Index Files
  Attribute                                                Maximum ---  Number of records per table file                         1 billion   #1 Number of characters per record                         65,500 Number of fields per record                             255 Number of tables open at one time                       225         #2 Number of characters per table field                    254 Number of characters per index key (.IDX)               100 Number of characters per index key (.CDX)               240 Number of open index files per table                    unlimited   #3 Number of open indexes in all work areas                unlimited   #3
 * 1) The actual file size (in bytes) cannot exceed two gigabytes for single user or exclusively opened multi-user .DBF files. Shared multi-user .DBF files with no indexes or .IDX indexes cannot exceed one gigabyte. Shared multi-user .DBF files with structural .CDX indexes cannot exceed two gigabytes.
 * 2) This is true of FoxPro Extended and FoxPro for Windows. FoxPro for MS-DOS is limited to 25 tables open at one time.
 * 3) Limited by memory and available file handles. Note that .CDX files use only one file handle.

Field Characteristics
  Attribute                                                Maximum Size of character fields                                254 Size of numeric (and float) fields                      20 Maximum number of characters in field names             10 Digits of precision in numeric computations             16 NOTE: Some capacities may be limited by available memory.

Additional query words: spec specs limit limits 3.00

Keywords: KB113441

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.