freechain error

[Jeff Harrison]

--- Dennis Malen <dmalen at malen.com> wrote:

> I don't know. Just John Esak's thought. He turned
> out to be right.
> 
> Dennis

I have seen a situation where the lookup - caused the
freechain to get corrupted also.  This was several
years ago.  I reported it to fptech, but I was unable
to come up with a duplicable scenario.

Unfortunately the process would work 99.9% of the
time.  When the freechain got corrupted the whole
application would lock up with record zero locked as I
recall.  I ended writing my own freechain program that
simply wrote a zero to the freechain pointer in the
key header record.  Then I had filepro rebuild the
freechain on this file on a weekly basis.

Of course the fact that the freechain was corrupted
for you does not explain why when you ran the
freechain program it returned immediately.  Is you
system so fast that it ran through 25,000 records in a
fraction of a second?

Jeff Harrison
jeffaharrison at yahoo.com

------------------------------------------------------
Author of JHImport and JHExport.  The fastest and 
easiest way to create code for filePro Imports
and Exports.
------------------------------------------------------


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com