Data corruption

Don Coleman dcoleman at dgcreact.com
Thu Dec 13 06:57:34 PST 2007


> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Wednesday, December 12, 2007 5:55 PM
> To: Don Coleman
> Cc: 'Filepro-List at Lists. Celestial. Com'
> Subject: RE: Data corruption
> 
> Quoting Don Coleman (Wed, 12 Dec 2007 14:49:00 -0500):
> 
> [...]
> >> >  So I'm thinking I can write a
> >> > clerk process to update, then save, then delete these records.
> >>
> >> Just remember that, being deleted records, you can't select them via
> the
> >> normal methods.
> [...]
> >> > a graphic dash.  Yet if I run a report with the debug on and I
> display
> >> the
> >> > value contained in this field I get 00000211.  Why does the debugger
> >> display
> >> > something different than the screen?  This wouldn't be so bad except
> >> this
> >> > file contains 1.6M records.  One at a time may take a while.
> >>
> >> How did you get to the record in a report?  If the header marks the
> record
> >> as deleted, no selection set (not even the "-a" flag) will select it.
> >
> > I ran the report (just a simple listing) with a selection set of @RN eq
> 13
> > (one of the corrupted records).  I then displayed the field value in the
> > debugger.  However, the report didn't actually print.
> 
> If record 13 is marked deleted because it's one of the corrupted records,
> then it won't be selected.  What processing were you in when in the
> debugger?  Were you, perchance, in @DONE?  Check @RN and @TS.
> 
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com


Ken:

Yesterday I thought I had just run a simple listing from dreport with the
debugger on.  However, when I tried to replicate this today it doesn't
select record #13 from a selection set nor does it select it when put into a
select table.  So you're your premise is correct.  Is my only option looking
for bad data on a manual view screen?



Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302



More information about the Filepro-list mailing list