FiveTech Software tech support forums

Code: Select all

SELECT (cAlias)
FOR nI:= 1 TO 1000000000   // Hasta donde el cuerpo aguante o la dbf no aguante mas
   APPEND BLANK
NEXT
 

Code: Select all

Description
 Length
 
Maximum number of index orders per compound index file
 50
 
Maximum number of index files open per table
 15
 
Maximum file size
  
 
Windows with NTFS
 2 gigabytes (2,147,483,648 bytes) multiplied by record length
 
Windows with FAT32
 4 gigabytes (4,294,967,296 bytes)
 
NetWare 5 and greater with NSS file systems*
 2 gigabytes (2,147,483,648 bytes) multiplied by record length
 
NetWare 5 and greater with traditional file systems
 4 gigabytes (4,294,967,296 bytes)
 
Linux pre-2.1.2 - 11 glibc and pre-2.4 kernel
 2 gigabytes (2,147,483,648 bytes)
 
Linux glibc 2.1.2 - 11+ with kernel 2.4+
 2 gigabytes (2,147,483,648 bytes) multiplied by record length
 
Maximum index size
 4 gigabytes (4,294,967,296 bytes)
 
Maximum memo file size
  
 
Windows with NTFS
 4 gigabytes multiplied by (Memo Page Size) : Max 4 terabytes
 
Windows with FAT32
 4 gigabytes (4,294,967,296 bytes)
 
NetWare 5 and greater with NSS file systems*
 4 gigabytes multiplied by (Memo Page Size) : Max 4 terabytes
 
NetWare 5 and greater with traditional file systems
 4 gigabytes (4,294,967,296 bytes)
 
Linux pre-2.1.2 - 11 glibc and pre-2.4 kernel
 2 gigabytes (2,147,483,648 bytes)
 
Linux glibc 2.1.2 - 11+ with kernel 2.4+
 4 gigabytes multiplied by (Memo Page Size) : Max 4 terabytes
 
Maximum database size
 No maximum - limited by disk space only
 
Maximum number of records per table
 2 billion
 
Maximum record length
 65530 bytes
 
Maximum field name length
 10 characters for traditional Xbase DBFs. 128 characters for Visual FoxPro (VFP) tables associated with a data dictionary.
 
Maximum index order name length
 10 characters
 
Characters allowed in field names
 Characters ‘a’-‘z’ and ‘A’-‘Z’, digits ‘0’-‘9’, and the underscore ‘_’ character
 
Characters allowed in index order names
 Characters ‘a’-‘z’ and ‘A’-‘Z’, digits ‘0’-‘9’, and the underscore ‘_’ character
 
Maximum amount of data per binary/image/BLOB field
 4 gigabytes
 
Maximum number of fields per table
 2035
 
Maximum traditional record filter expression text length
 65,534 characters
 
Maximum Advantage Optimized Filter (AOF) expression text length
 65,534 characters
 
Maximum number of transactions
 Limited by memory
 
Maximum number of connections
 Limited by memory
 
Maximum number of files opened simultaneously
 Limited by memory
 
Maximum number of locks
 Limited by memory
 

* With NetWare 5 and greater, file sizes greater than 4GB require a special build of ads.nlm in conjunction with a certain NetWare support pack. Contact your Advantage distributor for more information.

 

Maximum length of key expression text and maximum length of conditional expression text
 NTX
 256 bytes
 
 
 IDX (non-compact)
 220 bytes
 
 
 IDX (compact)
 512 bytes**
 
 
 CDX
 512 bytes**
 
 
  
  
 
Maximum length of evaluated key expression
 NTX
 256 bytes
 
 
 IDX (non-compact)
 100 bytes
 
 
 IDX (compact)
 240 bytes
 
 
 CDX
 240 bytes
 

 

** The combined length of the index key expression text and conditional expression text must not be longer than 512 bytes