Field expansion question

Kenneth Brody kenbrody at bestweb.net
Tue Jan 23 08:03:31 PST 2007


Quoting Brian K. White (Mon, 22 Jan 2007 22:30:57 -0500):

[... changing field lengths in ddefine ...]

[...]
> II forget which wy it adds the spaces, and whether it does the sane
> thing depending on the edit.
> If it's a numeric field and it adds the spaces on the left, then the
> reindex will be all you need, but if it adds the space to the wrong side
> I don't think a reindex will fix it, You might need to make up a little
> one-line report in each file to re-save the field.
[...]

Changing field lengths and edits in ddefine causes filePro to massage
the data in the same way as if you did something like:

    newfield(newlen,newtype) = oldfield(oldlen,oldtype)

So, moving changing a (6,*) field to (7,*) as in the OP, the net result
will be a space added to the end of the field.

Changing (8,ymd/) to (10,mdyy/) will result in the date being converted
from YY/MM/DD to MM/DD/YYYY.

--
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