Data corruption

Kenneth Brody kenbrody at bestweb.net
Wed Dec 12 11:41:42 PST 2007


Quoting Don Coleman (Wed, 12 Dec 2007 14:29:48 -0500):
[...]
> Updating the record, then saving the record does allow record deletion.
> Thank you.
>
> Next question.  If I am displaying one of the corrupted records on the
> screen, each field appears to contain a straight line similar to the
> graphics characters in dscreen & dmoedef.

If it's the horizontal line, and this is Windows (which you said it was),
then that's a binary zero -- CHR("0").  That fits with the symptom of the
record being seen as unused, which would be marked by the first byte in
the header being zero.

>  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.

>  Next task is
> to make sure I correctly identify the corrupted records in the file.  To
> test (not a complete test) I check each position of an 8 character * edit
> field where each position should range from 0-9.  Again, the screen displays
> 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.

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list