DelphiFAQ Home Search:
General :: Programming :: Delphi :: Database
Database development with Delphi. Includes issues with BDE, ADO and InterBase.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Only the 40 most recently viewed articles are shown.
You can see the full list here.

Featured Article

FoxPro limits

Max. # of records per table1 billion*
Max. # of chars per record65,000
Max. # of fields per record255
Max. # of open DBFs225
Max. # of chars per field254
Max. # of chars per index key (IDX)100
Max. # of chars per index key (CDX)240
Max. # of open index files per tableunlimited**
Max. # of open index files in all work areasunlimited**

* The actual file size (in bytes) cannot exceed 2 gigabytes for single-user or exclusively opened multi-user tables. Shared tables with no indexes or .IDX indexes cannot exceed 1 gigabyte. Shared tables with structural .CDX indexes cannot exceed 2 gigabytes.

** Limited by memory. In FoxPro for MS-DOS and FoxPro for Windows, also limited by available MS-DOS file handles. Each .CDX file uses only 1 file handle. The number of MS-DOS file handles is determined by the CONFIG.SYS FILES parameter.

Field Characteristics

Max. size of character fields254
Max. size of numeric fields20
Max. # of chars in field names10
Digits of precision in numeric computations16

Generated 4:01:10 on Apr 6, 2020