Approximating the Size of a .DBF File in FoxBASE+ (88983)



The information in this article applies to:

  • Microsoft FoxBASE+ for MS-DOS 1.21
  • Microsoft FoxBASE+ for MS-DOS 2.1

This article was previously published under Q88983

SUMMARY

The following formula approximates the space required to store a .DBF database file:
   RECSIZE() * (RECCOUNT() + 1)
				
The RECSIZE() function returns the number of bytes for each record, and the RECCOUNT() function returns the number of records in the .DBF file.

This can be very useful when trying to write backup routines for an application. This could be used in conjunction with the DISKSPACE() function to determine if the backup copy of the database would fit on a disk.

Modification Type:MajorLast Reviewed:9/30/2003
Keywords:KB88983