Corrupted keybackup

Richard Kreiss rkreiss at gccconsulting.net
Fri Jun 10 13:13:30 PDT 2011


I added 2 fields to the end of a file. One zero length and the other 5,.0.

Some of the records are ok and some are corrupted.  It appears that most of
the bad records are in the middle of the file.

Any backups they may have had from the time the fields were added are now
gone.  The primary key is ok.  On a monthly basis, the order details are
posted to the history file.  This is this and the backup are the ones that
are bad.

I know that fp i/o could be used to read in this file but I am not quite
sure how to approach handling what is read in.  I know what the record
length should be and what the length of each field is.  

I will assume that I have to get passed the 20 byte record header first and
then process the information.

When I looked as some of the records while stepping through the file by
record number, I noted that many of them had no creation date.  As such, the
filePro may be looking at these as blank records.

Any suggestion as to how I can straighten this out will be greatly
appreciated.

  

Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net
  









More information about the Filepro-list mailing list