OPEN QUERY FOR EACH EACH (1 in 1 files)

Filename Line # Column # Match Text
./abl/checkout.p 00083 00001
open [OPEN_QUERY] @83:1
   q-checkout [QUERY] @83:12
   for [KW_FOR] @84:4
      each [KW_EACH] @84:8
      record phrase [RECORD_PHRASE] @0:0
         checkout [TABLE] @84:13
         no-lock [KW_NO_LOCK] @84:22
      each [KW_EACH] @85:8
      record phrase [RECORD_PHRASE] @0:0
         reservation [TABLE] @85:13
         where [KW_WHERE] @86:10
            expression [EXPRESSION] @0:0
               and [KW_AND] @86:69
                  = [EQUALS] @86:43
                     reservation.reservation-id [FIELD_INT] @86:16
                     checkout.reservation-id [FIELD_INT] @86:45
                  ( [LPARENS] @88:17
                     or [KW_OR] @88:39
                        = [EQUALS] @88:33
                           checkout.state [FIELD_CHAR] @88:18
                           'I' [STRING] @88:35
                        = [EQUALS] @88:57
                           checkout.state [FIELD_CHAR] @88:42
                           "O" [STRING] @88:59
         no-lock [KW_NO_LOCK] @88:64
         use-index [KW_USE_IDX] @88:72
            idx-r-id [INDEX] @88:82

Conditions matched: [ evalLib("static_multi_table_record_retrieval", this) ]


Please see the Source File Index for the list of report inputs. Generated at 03/31/2017 21:16:32 EEST.