CalcIt Commands

SELECT
...
...
CASE(Condition)
...
...
ELSE
...
...
END

This command is used in cases of multiple IFs as a more comfortable way to do the same.

SELECT
 CASE(cond1);
  ....
  ....
 CASE(cond2);
  ....
  ....
 CASE(cond3);
  ....
  ....
 ELSE
  ....
  ....
END;

If one of the cont1, cont2, etc conditions returns TRUE(1) then the below statements are executed until the next CASE or the end of the SELECT command. If none of the conditions returns TRUE then the statements under ELSE are executed. ELSE is optional.

Go Back