FOXPRO System Index

FOXPRO System Index
　FoxPro 2. 5 Standard Edition FoxPro 2. FoxPro under 5 Enhanced Windows The maximum number of records per database L0 billion L0 billion 1 billion the maximum number of characters in each record    650006500065000 maximum number of fields per record 255 255255 max characters for each field   254254254 Maximum number of workspaces    25225225 maximum number of characters per IDX index keyword    100100l00 the maximum number of characters in each CDX index keyword expression 240240 240 The maximum number of index files that can be opened per database is limited by the maximum length of the available memory and the available file handles    maximum length of an unlimited number of fields   254254254 value field maximum length   202020 Maximum number of characters for a field name 10l010 numeric calculation precision (decimal bit)    161616 memory variable default value    256256256 memory variable Max    36006500065000 maximum number of arrays   36006500065000 maximum number of elements per array   36006500065000 source files maximum number of program lines    Unlimited unlimited number of individual procedures or custom functions   64k64k64k The maximum numbers of procedures or custom functions in each file    the maximum number of nested layers for do commands    Maximum number of nesting levels for 323232READ commands   555 The maximum number of nesting levels for a structured program command 646464 can open window Max count only limited by available memory and file handle the maximum number of browse windows that can be opened    25225225 maximum number of characters per command line    204820482048 maximum number of characters per macro substitution    204820482048 open files up to 99 only MS-DOS restrictions are restricted by MS-DOS only the maximum number of keystrokes per keyboard macro    1,024,102,410,241 SQL SELECT commands Maximum number of optional fields 255255255 each color group is the largest number of color patterns   Maximum number of 2424 color groups  Unlimited unlimited number of colors in each color mode   10L0 user-definable color modes 8 8 maximum number of targets in a report format definition is limited by available memory and file handles maximum number of rows in the report format   255255255 maximum number of levels in report format 202020 Note: If you are running in Single-user mode or open exclusively in a network environment, the actual length of a database cannot exceed 2 billion bytes. This restriction also applies to shared DBF files with structured CDX indexes. Shared files with no index or IDX index cannot be longer than 1 billion (approximately 1G) bytes.