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