FoxPro for Windows & MS-DOS Specifications & Limitations

ID: Q113441

The information in this article applies to:

Microsoft Visual Basic Standard and Professional Editions 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

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.

This is true of FoxPro Extended and FoxPro for Windows. FoxPro for MS-DOS is limited to 25 tables open at one time.

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 :
Version :
Platform :
Issue type :