Knowledge Base |

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

## 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 query words: spec specs limit limits 3.00

Keywords: KB113441