ProTech(tm)

Database Table Repair

Included with ProTech is code that can be built into a FoxPro application, as well as a general purpose scanning utility that searches for corrupted database files (FixFile.exe .. located in the fix_file subdirectory .. demonstrates a small stand-alone application that will scan a user supplied subdirectory for files with database header problems).

The following are checked and repaired by FIX_FILE:

• Database file type (dbf, dbf w/memo, etc)
• Position of first record (given data is not shifted)
• Number of fields
• Type of fields
• Length of fields per definition vs. record length in header
• Fields displaced within header
• Extra bytes at end of file
• Number of records in database
• Database file size
• CDX File to be loaded when the file is opened
   
• Memo files: Analyze header vs. fields requiring memo vs. existence of memo file.
• Next entry pointer
• Determines proper memo to use (FPT, DBT, PJT, SCT, FRT, MNT, LRT).
  This makes it simple to repair many of the project/screen/report types of database errors.
   
• Items analyzed and not repaired
• Potential that data was shifted
• Items not analyzed or repaired
• Missing data within file
• Shifted data within data portion of file
• Extra data inserted into file
• Corrupted data
• Actual Memo and General pointers
• When creating empty memo files, fix_file does not go back and void all memo and general pointers.

Users are given the option to backup data prior to repairs. Users are given information when repairing a file when a restoration from a backup may be in order. Process is very fast. All written in FoxPro! Compatible across Windows/DOS/Mac platforms. SHOULD even work from UNIX - but has not been tested on that platform.

ProTech is included with the ProTools collection.  ProTech may also be purchased separately.