Un-expanding(?) a File
Keith F Weatherhead
keithw at ddltd.com
Wed Jul 21 11:09:57 PDT 2004
Transpower at aol.com wrote:
> In a message dated 7/21/2004 1:21:48 PM Eastern Daylight Time,
> Fredland at aol.com writes:
>
>> Dear List:
>>
>> Back in 1985 or so I did a great deal of programming in filePro for a
>> small
>> airline and ever since then one of the vendors has been coming to me
>> whenever
>> he has a problem. In this case my memory of fp is not sufficient, but the
>> problem may contain elements of general interest so here it is.
>>
>> He is running his business on vers. 4.8. He has a file containing both
>> key
>> and data segments (very old program) and about 7000 records. It
>> appears that the
>> file has acquired about 7000 blank records possibly via Expand
>> Files(?). As a
>> result new records are often numbered 14000+. He doesn't want this to be
>> happening (it's not a functional problem - he simply doesn't like it
>> like that) so
>> he manually moves any such new records down to the 7000 range. He has
>> gotten
>> tired of doing this after several years and would like the file
>> "fixed". This
>> is the gist of a phone call from him.
>>
>> If memory serves (not very well any more) there is a difference
>> between blank
>> records and deleted records. I think, but do not know, that he may be
>> able to
>> delete his empty blank records with a simple output process and then
>> overwrite the expand files limit with a new number in the 7000 range a
>> couple of
>> records beyond his active EOF. Once these are used then I would expect
>> the
>> automated expand function built into FP to take over. I'm in the midst
>> of a major
>> renovation so do not have time to research this and am loath to
>> suggest an
>> unverified procedure. Any clarification would be appreciated.
>>
>> Fred Mindermann
>> fredland at aol.com
>
>
>
> Fred:
>
> 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.
This is ONLY good if he does not want to preserve Date/Time stamps
on the original records, _if that matters to him_?
I believe Bob Stockler has a program that will allow you to shrink
the file AND PRESERVE the Date/Time. I'm sure he will chime in shortly!
Regards,
Keith
> Regards,
> RWS
> Transpower Corporation
> www.transpowercorp.com
> transpower at aol.com
>
> Commercial and custom software manufacturing for engineering and
> management since 1976.
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Keith F. Weatherhead keithw at ddltd.com
Discus Data, LTD Voice: (815) 237-8467
3465 S Carbon Hill Rd Fax: (815) 237-8641
Braceville, IL 60407 Nat'l_Pager: (815) 768-8098
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
More information about the Filepro-list
mailing list