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.