OOPS, have just realized I posted this in the wrong area. I was reading a calculation post and forgot where I was.

Is there a limit on how many Eles If statments a script can have (I dont think a Case Statement will work for our project).

If I have counted correctly we will have about 20 Else If statments.

If 20 is not a problem, then just for a reference, is there a limit? We run a Filemaker Server 11 and Filemaker 11 Pro on our workstations (not sure if there was a limit based on version).

Michelle

I am not aware of any such limit. If there were one, it would be more likely of how many steps can you have in a script - regardless of what those steps are. However, no such limit is listed in the tech spec.

Thank you for the reply. That would make sense as to the number of script steps rather than a specific script step.

ML

When a script has that many Else If statements, I start to wonder if it would be easier to maintain as a group of smaller scripts rather than one giant script. Depends on its purpose, of course.

See: http://en.wikipedia.org/wiki/God_object

Wow, I never even thought of that. I think that may be a cleaner solution for our schools database.

It's arguably a matter of programming style, but I gravitate toward the style of manageable chunks of code, also called "what happens if I get hit by a bus?"