3 (27 in 5 files)

Filename Line # Column # Match Text
./abl/checkout.p 00267 00018
do [KW_DO] @267:18
./abl/checkout.p 00272 00032
do [KW_DO] @272:32
./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/guests.p 00166 00018
do [KW_DO] @166:18
./abl/guests.p 00176 00035
do [KW_DO] @176:35
./abl/guests.p 00181 00018
do [KW_DO] @181:18
./abl/guests.p 00206 00013
repeat [KW_REPEAT] @206:13
./abl/guests.p 00236 00013
repeat [KW_REPEAT] @236:13
   on [KW_ON] @236:20
      error [KW_ERROR] @236:23
      undo [KW_UNDO] @236:29
         add-guest [LABEL] @236:34
      leave [KW_LEAVE] @236:45
         add-guest [LABEL] @236:51
   on [KW_ON] @237:20
      endkey [KW_ENDKEY] @237:23
      undo [KW_UNDO] @237:30
         add-guest [LABEL] @237:35
      leave [KW_LEAVE] @237:46
         add-guest [LABEL] @237:52
./abl/guests.p 00292 00013
repeat [KW_REPEAT] @292:13
   on [KW_ON] @292:20
      endkey [KW_ENDKEY] @292:23
      undo [KW_UNDO] @292:30
         u-guest [LABEL] @292:35
      retry [KW_RETRY] @292:44
         u-guest [LABEL] @292:50
./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/reservations.p 00222 00013
do [KW_DO] @222:13
   transaction [KW_TRANS] @222:16
   on [KW_ON] @222:28
      error [KW_ERROR] @222:31
      undo [KW_UNDO] @222:37
      leave [KW_LEAVE] @222:43
   on [KW_ON] @223:28
      endkey [KW_ENDKEY] @223:31
      undo [KW_UNDO] @223:38
      leave [KW_LEAVE] @223:44
./abl/reservations.p 00386 00018
do [KW_DO] @386:18
./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 00427 00013
repeat [KW_REPEAT] @427:13
   on [KW_ON] @427:20
      error [KW_ERROR] @427:23
      undo [KW_UNDO] @427:29
      next [KW_NEXT] @427:35
./abl/reservations.p 00449 00013
repeat [KW_REPEAT] @449:13
   on [KW_ON] @449:20
      endkey [KW_ENDKEY] @449:23
      undo [KW_UNDO] @449:30
         ADD-RES [LABEL] @449:35
      leave [KW_LEAVE] @449:44
         ADD-RES [LABEL] @449:50
   on [KW_ON] @450:20
      error [KW_ERROR] @450:23
      undo [KW_UNDO] @450:29
         ADD-RES [LABEL] @450:34
      leave [KW_LEAVE] @450:43
         ADD-RES [LABEL] @450:49
./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 00683 00034
do [KW_DO] @683:34
./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.p 00161 00018
do [KW_DO] @161:18
./abl/rooms.p 00164 00018
do [KW_DO] @164:18
./abl/rooms.p 00190 00018
do [KW_DO] @190:18
./abl/rooms.p 00193 00018
do [KW_DO] @193:18

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


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