for [KW_FOR] (27 in 6 files)

Filename Line # Column # Match Text
./abl/checkout.p 00117 00004
for [KW_FOR] @117:4
   each [KW_EACH] @117:8
   record phrase [RECORD_PHRASE] @0:0
      b-out-room [BUFFER] @117:13
      where [KW_WHERE] @117:24
         expression [EXPRESSION] @0:0
            = [EQUALS] @117:56
               b-out-room.reservation-id [FIELD_INT] @117:30
               reservation.reservation-id [FIELD_INT] @117:58
./abl/checkout.p 00284 00013
for [KW_FOR] @284:13
   each [KW_EACH] @284:17
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @284:22
      where [KW_WHERE] @285:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @285:105
               ( [LPARENS] @285:22
                  if [FUNC_POLY] @285:23
                     or [KW_OR] @285:36
                        = [EQUALS] @285:32
                           g-f-n [VAR_CHAR] @285:26
                           ? [UNKNOWN_VAL] @285:34
                        = [EQUALS] @285:45
                           g-f-n [VAR_CHAR] @285:39
                           "" [STRING] @285:47
                     true [BOOL_TRUE] @285:55
                     matches [KW_MATCHES] @285:84
                        b-guest.first-name [FIELD_CHAR] @285:65
                        + [PLUS] @285:98
                           g-f-n [VAR_CHAR] @285:92
                           "*" [STRING] @285:100
               ( [LPARENS] @286:22
                  if [FUNC_POLY] @286:23
                     or [KW_OR] @286:36
                        = [EQUALS] @286:32
                           g-l-n [VAR_CHAR] @286:26
                           ? [UNKNOWN_VAL] @286:34
                        = [EQUALS] @286:45
                           g-l-n [VAR_CHAR] @286:39
                           "" [STRING] @286:47
                     true [BOOL_TRUE] @286:55
                     matches [KW_MATCHES] @286:83
                        b-guest.last-name [FIELD_CHAR] @286:65
                        + [PLUS] @286:97
                           g-l-n [VAR_CHAR] @286:91
                           "*" [STRING] @286:99
      no-lock [KW_NO_LOCK] @286:104
   each [KW_EACH] @287:17
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @287:22
      where [KW_WHERE] @287:28
         expression [EXPRESSION] @0:0
            >= [GTE] @287:49
               b-res.checkout [FIELD_DATE] @287:34
               today [FUNC_DATE] @287:52
      use-index [KW_USE_IDX] @287:58
         idx-r-checkin [INDEX] @287:68
      no-lock [KW_NO_LOCK] @287:82
   each [KW_EACH] @288:17
   record phrase [RECORD_PHRASE] @0:0
      b-out-room [BUFFER] @288:22
      where [KW_WHERE] @288:33
         expression [EXPRESSION] @0:0
            and [KW_AND] @288:88
               = [EQUALS] @288:65
                  b-out-room.reservation-id [FIELD_INT] @288:39
                  b-res.reservation-id [FIELD_INT] @288:67
               ( [LPARENS] @289:22
                  or [KW_OR] @291:66
                     or [KW_OR] @290:66
                        or [KW_OR] @289:66
                           = [EQUALS] @289:47
                              b-out-room.guest-ids [FIELD_INT] @289:23
                                 [ [LBRACKET] @289:43
                                    1 [NUM_LITERAL] @289:44
                              b-guest.guest-id [FIELD_INT] @289:49
                           = [EQUALS] @290:47
                              b-out-room.guest-ids [FIELD_INT] @290:23
                                 [ [LBRACKET] @290:43
                                    2 [NUM_LITERAL] @290:44
                              b-guest.guest-id [FIELD_INT] @290:49
                        = [EQUALS] @291:47
                           b-out-room.guest-ids [FIELD_INT] @291:23
                              [ [LBRACKET] @291:43
                                 3 [NUM_LITERAL] @291:44
                           b-guest.guest-id [FIELD_INT] @291:49
                     = [EQUALS] @292:47
                        b-out-room.guest-ids [FIELD_INT] @292:23
                           [ [LBRACKET] @292:43
                              4 [NUM_LITERAL] @292:44
                        b-guest.guest-id [FIELD_INT] @292:49
      no-lock [KW_NO_LOCK] @292:67
./abl/checkout.p 00320 00013
for [KW_FOR] @320:13
   each [KW_EACH] @320:17
   record phrase [RECORD_PHRASE] @0:0
      b-out-room [BUFFER] @320:22
      where [KW_WHERE] @320:33
         expression [EXPRESSION] @0:0
            = [EQUALS] @320:65
               b-out-room.reservation-id [FIELD_INT] @320:39
               reservation.reservation-id [FIELD_INT] @320:67
./abl/checkout.p 00334 00013
for [KW_FOR] @334:13
   each [KW_EACH] @334:17
   record phrase [RECORD_PHRASE] @0:0
      b-out-room [BUFFER] @334:22
      where [KW_WHERE] @334:33
         expression [EXPRESSION] @0:0
            = [EQUALS] @334:65
               b-out-room.reservation-id [FIELD_INT] @334:39
               reservation.reservation-id [FIELD_INT] @334:67
./abl/empty-db.p 00001 00001
for [KW_FOR] @1:1
   each [KW_EACH] @1:5
   record phrase [RECORD_PHRASE] @0:0
      checkout [TABLE] @1:10
./abl/empty-db.p 00002 00001
for [KW_FOR] @2:1
   each [KW_EACH] @2:5
   record phrase [RECORD_PHRASE] @0:0
      checkout-rooms [TABLE] @2:10
./abl/empty-db.p 00003 00001
for [KW_FOR] @3:1
   each [KW_EACH] @3:5
   record phrase [RECORD_PHRASE] @0:0
      guest [TABLE] @3:10
./abl/empty-db.p 00004 00001
for [KW_FOR] @4:1
   each [KW_EACH] @4:5
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @4:10
./abl/empty-db.p 00005 00001
for [KW_FOR] @5:1
   each [KW_EACH] @5:5
   record phrase [RECORD_PHRASE] @0:0
      reservation [TABLE] @5:10
./abl/empty-db.p 00006 00001
for [KW_FOR] @6:1
   each [KW_EACH] @6:5
   record phrase [RECORD_PHRASE] @0:0
      reservation-rooms [TABLE] @6:10
./abl/empty-db.p 00007 00001
for [KW_FOR] @7:1
   each [KW_EACH] @7:5
   record phrase [RECORD_PHRASE] @0:0
      room [TABLE] @7:10
./abl/empty-db.p 00008 00001
for [KW_FOR] @8:1
   each [KW_EACH] @8:5
   record phrase [RECORD_PHRASE] @0:0
      room-state [TABLE] @8:10
./abl/rates-report.p 00104 00010
for [KW_FOR] @104:10
   each [KW_EACH] @104:14
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @104:19
   each [KW_EACH] @105:13
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @105:18
      where [KW_WHERE] @106:16
         expression [EXPRESSION] @0:0
            ( [LPARENS] @106:22
               if [FUNC_POLY] @106:23
                  by-room [VAR_LOGICAL] @106:26
                  = [EQUALS] @106:56
                     t-room-type.type [FIELD_INT] @106:39
                     room-type [VAR_INT] @106:58
                  true [BOOL_TRUE] @106:73
   each [KW_EACH] @107:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @107:18
      where [KW_WHERE] @108:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @110:87
               and [KW_AND] @109:59
                  and [KW_AND] @108:49
                     = [EQUALS] @108:33
                        rate.floor [FIELD_INT] @108:22
                        t-floor.floor [FIELD_INT] @108:35
                     = [EQUALS] @109:40
                        rate.type-of-room [FIELD_INT] @109:22
                        t-room-type.type [FIELD_INT] @109:42
                  ( [LPARENS] @110:22
                     if [FUNC_POLY] @110:23
                        = [EQUALS] @110:37
                           start-date [VAR_DATE] @110:26
                           ? [UNKNOWN_VAL] @110:39
                        true [BOOL_TRUE] @110:46
                        <= [LTE] @110:72
                           rate.start-date [FIELD_DATE] @110:56
                           start-date [VAR_DATE] @110:75
               ( [LPARENS] @111:22
                  if [FUNC_POLY] @111:23
                     = [EQUALS] @111:35
                        end-date [VAR_DATE] @111:26
                        ? [UNKNOWN_VAL] @111:37
                     true [BOOL_TRUE] @111:44
                     >= [GTE] @111:68
                        rate.end-date [FIELD_DATE] @111:54
                        end-date [VAR_DATE] @111:71
      no-lock [KW_NO_LOCK] @112:16
   break [KW_BREAK] @113:13
   by [KW_BY] @113:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @113:22
   by [KW_BY] @114:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @114:22
./abl/rates-report.p 00147 00010
for [KW_FOR] @147:10
   each [KW_EACH] @147:14
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @147:19
      where [KW_WHERE] @148:16
         expression [EXPRESSION] @0:0
            ( [LPARENS] @148:22
               if [FUNC_POLY] @148:23
                  by-room [VAR_LOGICAL] @148:26
                  = [EQUALS] @148:56
                     t-room-type.type [FIELD_INT] @148:39
                     room-type [VAR_INT] @148:58
                  true [BOOL_TRUE] @148:73
   each [KW_EACH] @149:13
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @149:18
   each [KW_EACH] @150:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @150:18
      where [KW_WHERE] @151:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @153:87
               and [KW_AND] @152:59
                  and [KW_AND] @151:49
                     = [EQUALS] @151:33
                        rate.floor [FIELD_INT] @151:22
                        t-floor.floor [FIELD_INT] @151:35
                     = [EQUALS] @152:40
                        rate.type-of-room [FIELD_INT] @152:22
                        t-room-type.type [FIELD_INT] @152:42
                  ( [LPARENS] @153:22
                     if [FUNC_POLY] @153:23
                        = [EQUALS] @153:37
                           start-date [VAR_DATE] @153:26
                           ? [UNKNOWN_VAL] @153:39
                        true [BOOL_TRUE] @153:46
                        <= [LTE] @153:72
                           rate.start-date [FIELD_DATE] @153:56
                           start-date [VAR_DATE] @153:75
               ( [LPARENS] @154:22
                  if [FUNC_POLY] @154:23
                     = [EQUALS] @154:35
                        end-date [VAR_DATE] @154:26
                        ? [UNKNOWN_VAL] @154:37
                     true [BOOL_TRUE] @154:44
                     >= [GTE] @154:68
                        rate.end-date [FIELD_DATE] @154:54
                        end-date [VAR_DATE] @154:71
      no-lock [KW_NO_LOCK] @155:16
   break [KW_BREAK] @156:13
   by [KW_BY] @156:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @156:22
   by [KW_BY] @157:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @157:22
./abl/rates-report.p 00252 00010
for [KW_FOR] @252:10
   each [KW_EACH] @252:14
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @252:19
   each [KW_EACH] @253:13
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @253:18
      where [KW_WHERE] @254:16
         expression [EXPRESSION] @0:0
            ( [LPARENS] @254:22
               if [FUNC_POLY] @254:23
                  by-room [VAR_LOGICAL] @254:26
                  = [EQUALS] @254:56
                     t-room-type.type [FIELD_INT] @254:39
                     room-type [VAR_INT] @254:58
                  true [BOOL_TRUE] @254:73
   each [KW_EACH] @255:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @255:18
      where [KW_WHERE] @256:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @258:87
               and [KW_AND] @257:59
                  and [KW_AND] @256:49
                     = [EQUALS] @256:33
                        rate.floor [FIELD_INT] @256:22
                        t-floor.floor [FIELD_INT] @256:35
                     = [EQUALS] @257:40
                        rate.type-of-room [FIELD_INT] @257:22
                        t-room-type.type [FIELD_INT] @257:42
                  ( [LPARENS] @258:22
                     if [FUNC_POLY] @258:23
                        = [EQUALS] @258:37
                           start-date [VAR_DATE] @258:26
                           ? [UNKNOWN_VAL] @258:39
                        true [BOOL_TRUE] @258:46
                        <= [LTE] @258:72
                           rate.start-date [FIELD_DATE] @258:56
                           start-date [VAR_DATE] @258:75
               ( [LPARENS] @259:22
                  if [FUNC_POLY] @259:23
                     = [EQUALS] @259:35
                        end-date [VAR_DATE] @259:26
                        ? [UNKNOWN_VAL] @259:37
                     true [BOOL_TRUE] @259:44
                     >= [GTE] @259:68
                        rate.end-date [FIELD_DATE] @259:54
                        end-date [VAR_DATE] @259:71
      no-lock [KW_NO_LOCK] @260:16
   break [KW_BREAK] @261:13
   by [KW_BY] @261:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @261:22
   by [KW_BY] @262:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @262:22
./abl/rates-report.p 00295 00010
for [KW_FOR] @295:10
   each [KW_EACH] @295:14
   record phrase [RECORD_PHRASE] @0:0
      t-room-type [TEMP_TABLE] @295:19
      where [KW_WHERE] @296:16
         expression [EXPRESSION] @0:0
            ( [LPARENS] @296:22
               if [FUNC_POLY] @296:23
                  by-room [VAR_LOGICAL] @296:26
                  = [EQUALS] @296:56
                     t-room-type.type [FIELD_INT] @296:39
                     room-type [VAR_INT] @296:58
                  true [BOOL_TRUE] @296:73
   each [KW_EACH] @297:13
   record phrase [RECORD_PHRASE] @0:0
      t-floor [TEMP_TABLE] @297:18
   each [KW_EACH] @298:13
   record phrase [RECORD_PHRASE] @0:0
      rate [TABLE] @298:18
      where [KW_WHERE] @299:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @301:87
               and [KW_AND] @300:59
                  and [KW_AND] @299:49
                     = [EQUALS] @299:33
                        rate.floor [FIELD_INT] @299:22
                        t-floor.floor [FIELD_INT] @299:35
                     = [EQUALS] @300:40
                        rate.type-of-room [FIELD_INT] @300:22
                        t-room-type.type [FIELD_INT] @300:42
                  ( [LPARENS] @301:22
                     if [FUNC_POLY] @301:23
                        = [EQUALS] @301:37
                           start-date [VAR_DATE] @301:26
                           ? [UNKNOWN_VAL] @301:39
                        true [BOOL_TRUE] @301:46
                        <= [LTE] @301:72
                           rate.start-date [FIELD_DATE] @301:56
                           start-date [VAR_DATE] @301:75
               ( [LPARENS] @302:22
                  if [FUNC_POLY] @302:23
                     = [EQUALS] @302:35
                        end-date [VAR_DATE] @302:26
                        ? [UNKNOWN_VAL] @302:37
                     true [BOOL_TRUE] @302:44
                     >= [GTE] @302:68
                        rate.end-date [FIELD_DATE] @302:54
                        end-date [VAR_DATE] @302:71
      no-lock [KW_NO_LOCK] @303:16
   break [KW_BREAK] @304:13
   by [KW_BY] @304:19
      expression [EXPRESSION] @0:0
         t-room-type.type [FIELD_INT] @304:22
   by [KW_BY] @305:19
      expression [EXPRESSION] @0:0
         t-floor.floor [FIELD_INT] @305:22
./abl/rates.p 00141 00007
for [KW_FOR] @141:7
   each [KW_EACH] @141:11
   record phrase [RECORD_PHRASE] @0:0
      b-rate [BUFFER] @141:16
      where [KW_WHERE] @141:23
         expression [EXPRESSION] @0:0
            = [EQUALS] @141:42
               b-rate.floor [FIELD_INT] @141:29
               f-to [VAR_INT] @141:44
./abl/rates.p 00145 00007
for [KW_FOR] @145:7
   each [KW_EACH] @145:11
   record phrase [RECORD_PHRASE] @0:0
      b-rate [BUFFER] @145:16
      where [KW_WHERE] @145:23
         expression [EXPRESSION] @0:0
            = [EQUALS] @145:42
               b-rate.floor [FIELD_INT] @145:29
               f-from [VAR_INT] @145:44
./abl/reservations.p 00151 00005
for [KW_FOR] @151:5
   each [KW_EACH] @151:9
   record phrase [RECORD_PHRASE] @0:0
      b-res-room [BUFFER] @151:14
      where [KW_WHERE] @151:25
         expression [EXPRESSION] @0:0
            = [EQUALS] @151:57
               b-res-room.reservation-id [FIELD_INT] @151:31
               r-id [VAR_INT] @151:59
./abl/reservations.p 00188 00007
for [KW_FOR] @188:7
   each [KW_EACH] @188:11
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @188:16
      where [KW_WHERE] @189:10
         expression [EXPRESSION] @0:0
            and [KW_AND] @190:98
               and [KW_AND] @189:99
                  ( [LPARENS] @189:16
                     if [FUNC_POLY] @189:17
                        or [KW_OR] @189:30
                           = [EQUALS] @189:26
                              g-f-n [VAR_CHAR] @189:20
                              ? [UNKNOWN_VAL] @189:28
                           = [EQUALS] @189:39
                              g-f-n [VAR_CHAR] @189:33
                              "" [STRING] @189:41
                        true [BOOL_TRUE] @189:49
                        matches [KW_MATCHES] @189:78
                           b-guest.first-name [FIELD_CHAR] @189:59
                           + [PLUS] @189:92
                              g-f-n [VAR_CHAR] @189:86
                              "*" [STRING] @189:94
                  ( [LPARENS] @190:16
                     if [FUNC_POLY] @190:17
                        or [KW_OR] @190:30
                           = [EQUALS] @190:26
                              g-l-n [VAR_CHAR] @190:20
                              ? [UNKNOWN_VAL] @190:28
                           = [EQUALS] @190:39
                              g-l-n [VAR_CHAR] @190:33
                              "" [STRING] @190:41
                        true [BOOL_TRUE] @190:49
                        matches [KW_MATCHES] @190:77
                           b-guest.last-name [FIELD_CHAR] @190:59
                           + [PLUS] @190:91
                              g-l-n [VAR_CHAR] @190:85
                              "*" [STRING] @190:93
               ( [LPARENS] @191:16
                  if [FUNC_POLY] @191:17
                     = [EQUALS] @191:26
                        g-dob [VAR_DATE] @191:20
                        ? [UNKNOWN_VAL] @191:28
                     true [BOOL_TRUE] @191:35
                     = [EQUALS] @191:67
                        b-guest.date-of-birth [FIELD_DATE] @191:45
                        g-dob [VAR_DATE] @191:69
      no-lock [KW_NO_LOCK] @191:76
./abl/reservations.p 00391 00013
for [KW_FOR] @391:13
   each [KW_EACH] @391:17
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @391:22
      where [KW_WHERE] @392:16
         expression [EXPRESSION] @0:0
            and [KW_AND] @393:104
               and [KW_AND] @392:105
                  ( [LPARENS] @392:22
                     if [FUNC_POLY] @392:23
                        or [KW_OR] @392:36
                           = [EQUALS] @392:32
                              g-f-n [VAR_CHAR] @392:26
                              ? [UNKNOWN_VAL] @392:34
                           = [EQUALS] @392:45
                              g-f-n [VAR_CHAR] @392:39
                              "" [STRING] @392:47
                        true [BOOL_TRUE] @392:55
                        matches [KW_MATCHES] @392:84
                           b-guest.first-name [FIELD_CHAR] @392:65
                           + [PLUS] @392:98
                              g-f-n [VAR_CHAR] @392:92
                              "*" [STRING] @392:100
                  ( [LPARENS] @393:22
                     if [FUNC_POLY] @393:23
                        or [KW_OR] @393:36
                           = [EQUALS] @393:32
                              g-l-n [VAR_CHAR] @393:26
                              ? [UNKNOWN_VAL] @393:34
                           = [EQUALS] @393:45
                              g-l-n [VAR_CHAR] @393:39
                              "" [STRING] @393:47
                        true [BOOL_TRUE] @393:55
                        matches [KW_MATCHES] @393:83
                           b-guest.last-name [FIELD_CHAR] @393:65
                           + [PLUS] @393:97
                              g-l-n [VAR_CHAR] @393:91
                              "*" [STRING] @393:99
               ( [LPARENS] @394:22
                  if [FUNC_POLY] @394:23
                     = [EQUALS] @394:32
                        g-dob [VAR_DATE] @394:26
                        ? [UNKNOWN_VAL] @394:34
                     true [BOOL_TRUE] @394:41
                     = [EQUALS] @394:73
                        b-guest.date-of-birth [FIELD_DATE] @394:51
                        g-dob [VAR_DATE] @394:75
      no-lock [KW_NO_LOCK] @394:82
   first [KW_FIRST] @395:17
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @395:23
      where [KW_WHERE] @395:29
         expression [EXPRESSION] @0:0
            and [KW_AND] @395:69
               = [EQUALS] @395:50
                  b-res.guest-id [FIELD_INT] @395:35
                  b-guest.guest-id [FIELD_INT] @395:52
               >= [GTE] @395:88
                  b-res.checkout [FIELD_DATE] @395:73
                  today [FUNC_DATE] @395:91
      use-index [KW_USE_IDX] @395:97
         idx-r-checkin [INDEX] @395:107
./abl/reservations.p 00519 00019
for [KW_FOR] @519:19
   each [KW_EACH] @519:23
   record phrase [RECORD_PHRASE] @0:0
      room [TABLE] @519:28
      where [KW_WHERE] @519:33
         expression [EXPRESSION] @0:0
            = [EQUALS] @519:57
               room.type-of-room [FIELD_INT] @519:39
               r-r-type [VAR_INT] @519:59
      no-lock [KW_NO_LOCK] @519:68
./abl/reservations.p 00523 00019
for [KW_FOR] @523:19
   each [KW_EACH] @523:23
   record phrase [RECORD_PHRASE] @0:0
      b-res2 [BUFFER] @523:28
      where [KW_WHERE] @524:22
         expression [EXPRESSION] @0:0
            and [KW_AND] @524:89
               and [KW_AND] @524:56
                  >= [GTE] @524:43
                     b-res2.checkin [FIELD_DATE] @524:28
                     r-checkin [VAR_DATE] @524:46
                  <= [LTE] @524:76
                     b-res2.checkout [FIELD_DATE] @524:60
                     r-checkin [VAR_DATE] @524:79
               <> [NOT_EQ] @525:41
                  b-res2.state [FIELD_CHAR] @525:28
                  res-state-ch [VAR_CHAR] @525:44
                     [ [LBRACKET] @525:56
                        res-state-canceled [VAR_INT] @525:57
      no-lock [KW_NO_LOCK] @525:77
./abl/reservations.p 00586 00013
for [KW_FOR] @586:13
   each [KW_EACH] @586:17
   record phrase [RECORD_PHRASE] @0:0
      b-res-room [BUFFER] @586:22
      where [KW_WHERE] @586:33
         expression [EXPRESSION] @0:0
            = [EQUALS] @586:65
               b-res-room.reservation-id [FIELD_INT] @586:39
               b-res.reservation-id [FIELD_INT] @586:67
./abl/reservations.p 00613 00022
for [KW_FOR] @613:22
   each [KW_EACH] @613:26
   record phrase [RECORD_PHRASE] @0:0
      b-res2 [BUFFER] @613:31
      where [KW_WHERE] @613:38
         expression [EXPRESSION] @0:0
            and [KW_AND] @613:76
               >= [GTE] @613:59
                  b-res2.checkin [FIELD_DATE] @613:44
                  b-res.checkin [FIELD_DATE] @613:62
               <= [LTE] @613:95
                  b-res2.checkin [FIELD_DATE] @613:80
                  b-res.checkout [FIELD_DATE] @613:98
      no-lock [KW_NO_LOCK] @613:113
   each [KW_EACH] @614:25
   record phrase [RECORD_PHRASE] @0:0
      b-out-room2 [BUFFER] @614:30
      where [KW_WHERE] @615:28
         expression [EXPRESSION] @0:0
            and [KW_AND] @616:79
               and [KW_AND] @615:74
                  <> [NOT_EQ] @615:53
                     recid [FUNC_RECID] @615:34
                        b-out-room2 [BUFFER] @615:40
                     recid [FUNC_RECID] @615:56
                        b-out-room [BUFFER] @615:62
                  = [EQUALS] @616:58
                     b-out-room2.room-number [FIELD_INT] @616:34
                     b-room.room-number [FIELD_INT] @616:60
               = [EQUALS] @617:61
                  b-out-room2.reservation-id [FIELD_INT] @617:34
                  b-res2.reservation-id [FIELD_INT] @617:63
      no-lock [KW_NO_LOCK] @618:25
./abl/reservations.p 00700 00013
for [KW_FOR] @700:13
   each [KW_EACH] @700:17
   record phrase [RECORD_PHRASE] @0:0
      b-res-room [BUFFER] @700:22
      where [KW_WHERE] @700:33
         expression [EXPRESSION] @0:0
            = [EQUALS] @700:65
               b-res-room.reservation-id [FIELD_INT] @700:39
               b-res.reservation-id [FIELD_INT] @700:67
      exclusive-lock [KW_EXC_LOCK] @700:88
./abl/rooms-overview.p 00051 00004
for [KW_FOR] @51:4
   each [KW_EACH] @51:8
   record phrase [RECORD_PHRASE] @0:0
      room [TABLE] @51:13
      where [KW_WHERE] @51:18
         expression [EXPRESSION] @0:0
            and [KW_AND] @51:54
               = [EQUALS] @51:42
                  room.type-of-room [FIELD_INT] @51:24
                  room-type [VAR_INT] @51:44
               = [EQUALS] @51:69
                  room.floor [FIELD_INT] @51:58
                  f-no [VAR_INT] @51:71

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


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