<HTML><FONT FACE=arial,helvetica><HTML><FONT SIZE=2 PTSIZE=10 FAMILY="SANSSERIF" FACE="Arial" LANG="0">In a message dated 7/21/2004 1:21:48 PM Eastern Daylight Time, Fredland@aol.com writes:<BR>
<BR>
<BLOCKQUOTE TYPE=CITE style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">Dear List:<BR>
<BR>
Back in 1985 or so I did a great deal of programming in filePro for a small <BR>
airline and ever since then one of the vendors has been coming to me whenever <BR>
he has a problem. In this case my memory of fp is not sufficient, but the <BR>
problem may contain elements of general interest so here it is.<BR>
<BR>
He is running his business on vers. 4.8. He has a file containing both key <BR>
and data segments (very old program) and about 7000 records. It appears that the <BR>
file has acquired about 7000 blank records possibly via Expand Files(?). As a <BR>
result new records are often numbered 14000+. He doesn't want this to be <BR>
happening (it's not a functional problem - he simply doesn't like it like that) so <BR>
he manually moves any such new records down to the 7000 range. He has gotten <BR>
tired of doing this after several years and would like the file "fixed". This <BR>
is the gist of a phone call from him.<BR>
<BR>
If memory serves (not very well any more) there is a difference between blank <BR>
records and deleted records. I think, but do not know, that he may be able to <BR>
delete his empty blank records with a simple output process and then <BR>
overwrite the expand files limit with a new number in the 7000 range a couple of <BR>
records beyond his active EOF. Once these are used then I would expect the <BR>
automated expand function built into FP to take over. I'm in the midst of a major <BR>
renovation so do not have time to research this and am loath to suggest an <BR>
unverified procedure. Any clarification would be appreciated.<BR>
<BR>
Fred Mindermann<BR>
fredland@aol.com <BR>
</BLOCKQUOTE><BR>
<BR>
Fred:<BR>
<BR>
Make a clone of the file (with no records). Copy non-blank records of the original file to the clone. Delete the original file. Rename the clone to the original name.<BR>
<BR>
Regards,<BR>
RWS<BR>
Transpower Corporation<BR>
<A HREF="www.transpowercorp.com">www.transpowercorp.com</A><BR>
transpower@aol.com<BR>
<BR>
Commercial and custom software manufacturing for engineering and management since 1976.
</FONT></HTML>