I'm trying to create a compute field that will display the length of the data in a field. For example, if the field is an AlphaUpper(30) but there are only 12 characters in the stored value, I want it to return 12.
I've tried ({fieldname} size) and this returns 30.
Anybody know how to do this in LPL?
My end-goal is to create a constraint on PfiXrefValues SourceValue1-10 and DestinationValue1-10 so that the user can't enter a longer value than is configured in PfiXrefCode. I can't imagine why the developers didn't do this when it was developed, since they included the field size/type as part of the setup.
Thanks!
Kelly
