I have an Expression method:
LTRIM(COALESCE([ADDRNUM], "") + " " + COALESCE([ROADPREDIR],"") + " " + COALESCE([ROADNAME],"") + " " + COALESCE([ROADTYPE],"") + " " + COALESCE([UNIT],""))
It runs just fine on "create", although it does throw an error in the log:
Expression to be eval: LTRIM(COALESCE("4288", "") + " " + COALESCE("","") + " " + COALESCE("NEWBERRY","") + " " + COALESCE("RD","") + " " + COALESCE("",""))
Type mismatch: 'COALESCE'
However, the destination field DOES contain the correct data.
However, the same expression:
LTRIM(COALESCE([ADDRNUM], "") + " " + COALESCE([ROADPREDIR],"") + " " + COALESCE([ROADNAME],"") + " " + COALESCE([ROADTYPE],"") + " " + COALESCE([UNIT],"")) when run "manually" does NOT update the value when one of the fields (say ADDRNUM) is changed. It fails with the same error:
Expression to be eval: LTRIM(COALESCE("4270", "") + " " + COALESCE("","") + " " + COALESCE("NEWBERRY","") + " " + COALESCE("RD","") + " " + COALESCE("",""))
ERROR: evaluating the expression for feature in Address Points with OID of 162532
Type mismatch: 'COALESCE'
These are from the same edit. I changed the ADDRNUM from 4288 to 4270, and that change was recognized in the second expression, but nothing was done to the destination field.
I hope this is understandable. Thanks.