Upgrade to 13 breaks a formula?
I drag and drop photos into a DBase and have a calculation fields that strips off the long pathname and displays only the filename of the image in the container field. Formula is below (might be wrong as this place doesn't seem to let me copy paste)
Right(GetValue (Pic;4);Lengfth(GetValue ( Pic;4))-Position ( GetValue (Pic;4);"?";1,1))
It works like a champ. Until...I upgraded to FM13 Last night I dragged and dropped and no filename. I see 13 has new container calculations, so I tried replacing the formula with
GetContainerAttribute ( Pic;Filename) and all I get is a "?" in the field. I thought maybe the entire pathname would be too long to display so tried making it a much larger box, smaller font etc, but no joy.
I don't know why the old formula wouldn't work anymore. Any ideas"?"
Oh...images from prior to the upgrade, still display their names