On 29 Aug 2008, at 04:58, Tami Williams wrote:
In FileMaker 6 Yes, Y, True and T all translated to 1 and No, N,
False and F all translated to 0.
So, you could do stuff like have a serial number field "testID"
and have a text field "testYDisplay" with a the word "Yes" in it
and have another field "testCalc Txt" - a calc field with the
result = text - with this calc:
If(Left(testYDisplay, 1), testID, "")
and the result would be thant the testID value would show in the
testCalc Txt field.
All quite true. But it does seem like rather round-about programming,
doesn't it? I wonder why you didn't originally use If(testYDisplay =
"Yes"), testID, "")? Simpler, isn't it?
There would probably have been an advantage in being more Boolean,
and making your field a number field testYBoolean (with the value "1"
in it). For display, you could have shown this as Yes in the Boolean
options.
Anyway, I'm afraid you are going to have to change it. I'm sorry if
you have many of these calculations. It's just one of the many chores
to do in converting FMP6 to FMP7-9.
Are you actually converting or rewriting? I haven't converted
anything but a very simple solution -- so I've been able to deal with
all these kinds of things as part of the rewrite process. Converting
aint' easy...
Steve
