SeedCode Support Forum

have a Case statement which returns the error message ""There are too many seperators in this function".

???

we have about 140 test/result lines in this Case statement

we were able to click "okay" with no problems several times along the way, but when we entered the last lines and clicked okay, we got the eerror.

Iss thheere a llimit on the number of tests?

any ideas?

There is a length limit to calculations (which you can easily break up into two fields for avoid).

To see if this is it, try commenting out about 1/2 way through and ending it there, then move the commented ending down to 1/2 of the remaining calc, and then half of that remainder, etc. until you get the error.

(I should also say that sometime when I paste in from html editors, I get some weirdness in the calc dialog- removing trailing and leading spaces in FileMaker's calc editing window has always fixed it.)