File restructure bastardization
Nancy Palmquist
nlp at vss3.com
Fri Sep 23 08:04:16 PDT 2005
Kenneth Brody wrote:
> Quoting George Simon (Thu, 22 Sep 2005 11:36:58 -0400):
> [...]
>
>>>ObDisclaimer: This is not an official endorsement by fPTech, just
>>>my own opinion.
>>>
>>>Since you aren't changing the length of the fields, and the new type
>>>would accept the existing data as-is, with no effect on sort-order
>>>(in case there are indexes built on them), you could theoretically
>>>edit the map, changing "YESNO" to "*" or "ALLUP", even while people
>>>are using the file, with no ill effect.
>>>
>>>Of course, I would highly recommend trying this out on a test file
>>>first.
>
> [...]
>
>>Any time I've changed a field edit from anything to an asterisk,
>>re-structuring does not take place. I don't think (know?) that is true
>>for ALLUP.
>
>
> Changing a field type to "*" without changing its length does not
> trigger a restructure, as the field's contents would not change
> during such a restructure.
But the lockfile will not allow this kind of change if the file is in
use as indicated by the original posting. The only way to change the
map would be from outside of filePro.
I agree with all others - this is a very touchy type of change. If you
make any other change to the map your customers may crash entirely and
the data become corrupt.
I would suggest this be handled during the scheduled maintenance time.
Nancy
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list