Data corruption

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of Don Coleman
> Sent: Tuesday, December 11, 2007 12:36 PM
> To: 'Filepro-List at Lists. Celestial. Com'
> Subject: Data corruption
> 
> Client had a hard drive fail over the weekend.  I have 
> identified some data corruption in an archive file at this 
> point.  Most of the corrupted records are in small batches of 
> 20-50 records although a few are single individual records.  
> I am unable to delete the corrupted records (nothing happens 
> on the screen).  Is there any way to get rid of these?  The 
> hard drive failed during the backup and I can piece the data 
> together if I can eliminate the corrupted records.
> 
> Windows 2003 server, fPv5.0.13, WIN2000 & WINXP Pro clients.
> 
> Don Coleman
> Donald G. Coleman, Consultant
> 402 Andrew Circle
> Indiana, PA 15701
> dcoleman at dgcreact.com
> (724) 349-6302

More then likely the corrupted records are not marked as updated but
available.  This will keep the <D>-delete from deleting these records.

To manually delete these records, with no processing on them, at each
record, press <U> and the save.  Then press <D> and the record will be
deleted.  Not a quick way but it will delete those records you want to
delete.

Make sure you backup this file before you start as deleting the corrupted
records may cause problems in other records.

Also, it is possible that any bad data in the field the cursor enters may
need to be deleted as fp may not accept this data a correct for the edit.
Best to use a field with an * edit as it accepts almost everything.

Richard Kreiss
GCC Consulting