FOR EACH IF THEN

Owned by Lutz Fechner
Last updated: Sept 20, 2022
1 min read

FOR EACH statements

FOR EACH ...: IF ... THEN NEXT.

Coding an “IF ... THEN NEXT.” is only allowed if the condition cannot be added to the query. (e.g.: UDF UserDefinedFunction). A reason should be added as a comment why the condition is not expressed in the query.

FOR EACH ...: FIND [FIRST] {WHERE|OF} ... . IF AVAILABLE THEN DO:

The “FIND ...” should be included into the “FOR EACH” and if needed coded with an OUTER-JOIN.