Versions Compared

Old Version 4

changes.mady.by.user Peter Judge

Saved on

compared with

New Version Current

changes.mady.by.user Lutz Fechner

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
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.

...