Microsoft KB Archive/110968: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "<" to "<")
Line 57: Line 57:
<li>Is the record length invalid?
<li>Is the record length invalid?
<ul>
<ul>
<li>Record length &lt;= 1</li>
<li>Record length <= 1</li>
<li>Record length &gt; maximum record length</li></ul>
<li>Record length &gt; maximum record length</li></ul>
</li>
</li>
<li>Are there no fields?</li>
<li>Are there no fields?</li>
<li>Are there more fields than permitted?</li>
<li>Are there more fields than permitted?</li>
<li>Is the number of records &lt; 0?</li>
<li>Is the number of records < 0?</li>
<li>Is the file size invalid?
<li>Is the file size invalid?
<ul>
<ul>

Revision as of 15:19, 20 July 2020

Knowledge Base


INFO: FoxPro Header Check to Determine if Table is Corrupt

Article ID: 110968

Article Last Modified on 2/22/2005



APPLIES TO

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft FoxPro 2.5b
  • Microsoft FoxPro 2.5a
  • Microsoft FoxPro 2.5b
  • Microsoft FoxPro 2.6 Standard Edition
  • Microsoft FoxPro 2.5b for MS-DOS
  • Microsoft FoxPro 2.5a
  • Microsoft FoxPro 2.5b for MS-DOS
  • Microsoft FoxPro 2.6 for MS-DOS
  • Microsoft FoxPro 2.5b for Macintosh



This article was previously published under Q110968

SUMMARY

When opening a database file (.DBF), FoxPro checks the header for the following five conditions that indicate corruption in a table:

  1. Is the record length invalid?
    • Record length <= 1
    • Record length > maximum record length
  2. Are there no fields?
  3. Are there more fields than permitted?
  4. Is the number of records < 0?
  5. Is the file size invalid?
    • (Start-of-data + the # of records) * rec. length > file size
    NOTE: Start-of-data is where the first byte of the first record begins.


Keywords: kbinfo KB110968