BREAK statement

Forces an immediate exit from a WHILE loop. Only valid inside the DO clause of a WHILE statement.

Syntax

BREAK;

Example

CREATE FUNCTION BreakContinueDemo( 
   Value Integer, SkipMultiples Integer, StopValue Integer ) 
RETURNS INTEGER 
BEGIN  
   CREATE VARIABLE INTEGER Result = 0;  
   WHILE 0 < Value DO   
      IF VALUE = StopValue THEN   
          BREAK;   
      END IF;   
      IF SkipMultiples != 0 
        and VALUE mod SkipMultiples = 0 THEN   
         Value  = Value - 1;   
         CONTINUE;   
      END IF;   
      Result = Result + Value;   
      Value  = Value - 1;  
   END WHILE;  
   RETURN Result; 
END FUNCTION;