Data corruption
Kenneth Brody
kenbrody at bestweb.net
Wed Dec 12 14:55:12 PST 2007
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
More information about the Filepro-list
mailing list