Description of the system capacities for Visual FoxPro for Windows 3.0

This article was previously published under Q129632
This article has been archived. It is offered "as is" and will no longer be updated.
This articles lists Visual FoxPro's System capacities in the followingareas:

  • Tables and Index files.
  • Field Characteristics.
  • Memory Variables and Arrays.
  • Program and Procedure Files.
  • Report Designer Capacities.
  • Miscellaneous Capacities.
NOTE: Some of Visual FoxPro's capacities may be limited by availablememory.
Table and Index Files---------------------Maximum # of records per table file             1 billion  (1)Maximum size of a table file                    2 gigabytesMaximum # of characters per record                 65,500Maximum # of fields per record                        255Maximum # of tables open at one time                  255Maximum # of characters per table field               254Maximum # of characters per index key (.IDX)          100Maximum # of characters per index key (.CDX)          240Maximum # of open index files per table         unlimited  (2)Maximum # of open indexes in all work areas     unlimited  (2)Maximum # of relations                          unlimitedMaximum length of relational expressions        unlimitedField Characteristics---------------------Maximum size of character fields                      254Maximum size of numeric (and float) fields             20Maximum number of characters in field names   in a free table                                     10Maximum number of characters in field names   in a table contained in a database                 128Minimum value of an integer                -2,147,483,647Maximum value of an integer                 2,147,483,647Digits of precision in numeric computations            16Memory Variables and Arrays---------------------------Default # of memory variables                       1,024Maximum # of memory variables                      65,000Maximum # of arrays                                65,000Maximum # of elements per array                    65,000Program and Procedure Files---------------------------Maximum # of lines in source program files      unlimitedMaximum size of compiled program modules              64K  (3)Maximum # of procedures per file                unlimitedMaximum # of nested DO calls                          128Maximum # of READ nesting levels                        5Maximum # of nested structured programming commands   384Maximum # of procedure arguments                       27Maximum # of transactions                               5Report Designer Capacities--------------------------Maximum # of objects in a report definition     unlimited  (2)Maximum length of a report definition                  20 inchesMaximum # of grouping levels                          128Maximum length of character report variables          255Miscellaneous Capacities------------------------Maximum # of open windows (all types)           unlimited  (2)Maximum # of open Browse windows                      255Maximum # of characters per character string            2 gigabytesMaximum # of characters per command line            8,192Maximum # of characters per label control on   a report                                           252Maximum # of characters per macro subst. line       8,192Maximum # of open files  limited only by operating systemMaximum keystrokes in keyboard macro                1,024Maximum fields that can be selected by a SQLSELECT statement                                      255Notes-----(1) The actual file size (in bytes) cannot exceed two gigabytes forsingle-user or exclusively opened multiuser .DBF files. Shared multiuser.DBF files with no indexes or .IDX indexes cannot exceed one gigabyte. AllVisual FoxPro tables and shared multiuser 2.x .DBF files with structural.CDX indexes cannot exceed two gigabytes.(2) Limited by memory and available file handles. .CDX files use only onefile handle.(3) A program module is one procedure. A program or application can containan unlimited number of program modules.				

Article ID: 129632 - Last Review: 02/24/2014 08:20:04 - Revision: 3.1

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • kbnosurvey kbarchive kbenv KB129632