FoxPro for Windows & MS-DOS Specifications & Limitations

Last reviewed: June 21, 1995
Article ID: Q113441

The information in this article applies to:

- Standard and Professional Editions of Microsoft Visual Basic

  Programming System for Windows, version 3.0

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.

MORE INFORMATION

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 reference words: spec specs limit limits 3.00
KBCategory: kbref
KBSubcategory: RefsDoc RefsProd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 21, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.