Jump to content

IF THEN vs. CASE statments


This topic is 7570 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all,

I just inherited a database to work on.

In it are some calc fields that have multiple, nested, if then statements (about 35 each).

These calcs are unstored and take about a minute to calculate when I want to display the results on the layout.

I am trying to optimize the calcs, is there any speed difference in FMP(6.0) when evaluating multiple nested if then statements versus evaluating a single multi line case statement?

Opinions all?

TIA

Jerry.

Link to comment
Share on other sites

This topic is 7570 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.