FoxPro for Windows & MS-DOS Specifications & Limitations

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