Data corruption
Kenneth Brody
kenbrody at bestweb.net
Thu Dec 13 09:52:43 PST 2007
Quoting Don Coleman (Thu, 13 Dec 2007 09:57:34 -0500):
[...]
> 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?
One possible method of finding and re-deleting all deleted records:
Save the file as-is, "just in case".
Rebuild the freechain.
Lookup to that file, use NUMRECS() to get the number of records in
the file. Then, repeatedly lookup-free and fill one of the fields
with "~~~~~~~". Continue until lookupname[@RN] is greater than the
value of NUMRECS() that you saved above. (That means you have found
all free records in the file.)
Run another report that selects all records with "~~~~~~~" in that
field, and delete them.
--
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