FOR EACH
Formatting of FOR EACH blocks
FOR EACH Table1 WHERE Table1.Field
or
FOR EACH Table1 WHERE Table1.Field1 = xyz
AND Table1.Field >= xyz
AND Table1.Field <= xyz
NO-LOCK,
EACH|FIRST|LAST Table2 WHERE (Table2.Field = xyz
AND Table2.Field >= xyz)
OR (Table2.Field = xyz)
NO-LOCK
BY xxx
Remarks:
Place the lock statement (NO-LOCK|EXCLUSIVE-LOCK) on an individual line in more complex queries so that it clearly visible and can not be overseen.