FoxPro system indicator
FoxPro 2.5 Standard Edition
FoxPro 2.5 Enhanced FoxPro under Window
Maximum record in each database
L0 billion
L01 billion
The maximum number of characters contained in each record
65000
6500065000
The most field number of each record
255
255255
Maximum number of characters per field
254
254254
Maximum number of workspaces
25
225225
Maximum number of characters per IDX index keyword
100
100L00
Maximum number of characters in each CDX index keyword expression
240
240 240
Each database opens the maximum number of index files
Only limited by available memory and available file sorts
The maximum length of the relationship expression
Unlimited
Not limited
Maximum length of the character field
254
254254
Maximum length of numeric field
20
2020
The number of the most characters of the field name
10
L010
Accuracy (decimal)
16
1616
Default value for memory variables
256
256256
The maximum number of memory variables
3600
6500065000
Maximum number of groups
3600
6500065000
The number of most elements of each array
3600
6500065000
The maximum number of lines in the source file
Unlimited
Not limited
Minimum capacity for a single process or custom function
64K
64k64K
Up to the maximum number of procedures or custom functions per file
Unlimited
Not limited
The maximum number of nesting layers of the DO command
32
3232
The maximum number of nested layers of the read command
5
55
The maximum number of nested layers of structured program commands
64
6464
Open the maximum number of windows
Only limited by available memory and file handle
The maximum number of open Browse windows
25
225225
Most characters per command line
2048
20482048
Each macro replace the number of characters
2048
20482048
The maximum number of files can be opened
99
Limited only by MS-DOS limited by MS-DOS
Maximum number of keys for each keyboard macro
1024
10241024
A number of optional fields of a SQL SELECT command
255
255255
Maximum number of color patterns in each color group
twenty four
twenty four
Maximum number of color groups
Unlimited
Not limited
Most color numbers in each color mode
10
L0
User-defined number of color patterns
8
8
Number of most targets in the format definition
Only limited by available memory and file handle
The most large number of report formats
255
255255
Maximum number of report formats
20
2020
Note: If you run in a single user mode or open in an exclusive manner in a network environment, the actual length of a database cannot exceed 2 billion bytes. This limit is also applicable to shared DBF files that use structured CDX indexes. The length of shared files that do not index or use IDX indexes cannot exceed 1 billion (about 1g) bytes.
