no-lock [KW_NO_LOCK] (51 in 7 files)

Filename Line # Column # Match Text
./abl/checkout.p 00084 00022
record phrase [RECORD_PHRASE] @0:0
   checkout [TABLE] @84:13
   no-lock [KW_NO_LOCK] @84:22
./abl/checkout.p 00088 00064
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
./abl/checkout.p 00095 00071
record phrase [RECORD_PHRASE] @0:0
   checkout-room [TABLE] @94:16
   where [KW_WHERE] @95:10
      expression [EXPRESSION] @0:0
         = [EQUALS] @95:45
            checkout-room.reservation-id [FIELD_INT] @95:16
            checkout.reservation-id [FIELD_INT] @95:47
   no-lock [KW_NO_LOCK] @95:71
   use-index [KW_USE_IDX] @95:79
      idx-rc-room [INDEX] @95:89
./abl/checkout.p 00149 00068
record phrase [RECORD_PHRASE] @0:0
   guest [TABLE] @149:21
   where [KW_WHERE] @149:27
      expression [EXPRESSION] @0:0
         = [EQUALS] @149:48
            guest.guest-id [FIELD_INT] @149:33
            cr-guest-ids [VAR_INT] @149:50
               [ [LBRACKET] @149:62
                  gid [VAR_INT] @149:63
   no-lock [KW_NO_LOCK] @149:68
   no-error [KW_NO_ERROR] @149:76
./abl/checkout.p 00273 00076
record phrase [RECORD_PHRASE] @0:0
   b-out-room [BUFFER] @273:27
   where [KW_WHERE] @273:38
      expression [EXPRESSION] @0:0
         = [EQUALS] @273:67
            b-out-room.room-number [FIELD_INT] @273:44
            g-room [VAR_INT] @273:69
   no-lock [KW_NO_LOCK] @273:76
   no-error [KW_NO_ERROR] @273:84
./abl/checkout.p 00286 00104
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
./abl/checkout.p 00287 00082
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
./abl/checkout.p 00292 00067
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 00304 00064
record phrase [RECORD_PHRASE] @0:0
   checkout [TABLE] @304:18
   where [KW_WHERE] @304:27
      expression [EXPRESSION] @0:0
         = [EQUALS] @304:57
            checkout.reservation-id [FIELD_INT] @304:33
            r-id [VAR_INT] @304:59
   no-lock [KW_NO_LOCK] @304:64
./abl/checkout.p 00305 00070
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @305:18
   where [KW_WHERE] @305:30
      expression [EXPRESSION] @0:0
         = [EQUALS] @305:63
            reservation.reservation-id [FIELD_INT] @305:36
            r-id [VAR_INT] @305:65
   no-lock [KW_NO_LOCK] @305:70
./abl/checkout.p 00310 00116
record phrase [RECORD_PHRASE] @0:0
   checkout-room [TABLE] @310:18
   where [KW_WHERE] @310:32
      expression [EXPRESSION] @0:0
         and [KW_AND] @310:74
            = [EQUALS] @310:67
               checkout-room.reservation-id [FIELD_INT] @310:38
               r-id [VAR_INT] @310:69
            = [EQUALS] @310:104
               checkout-room.room-number [FIELD_INT] @310:78
               f-room-id [VAR_INT] @310:106
   no-lock [KW_NO_LOCK] @310:116
./abl/guests.p 00174 00101
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @171:24
   where [KW_WHERE] @172:16
      expression [EXPRESSION] @0:0
         and [KW_AND] @173:104
            and [KW_AND] @172:105
               ( [LPARENS] @172:22
                  if [FUNC_POLY] @172:23
                     or [KW_OR] @172:36
                        = [EQUALS] @172:32
                           g-f-n [VAR_CHAR] @172:26
                           ? [UNKNOWN_VAL] @172:34
                        = [EQUALS] @172:45
                           g-f-n [VAR_CHAR] @172:39
                           "" [STRING] @172:47
                     true [BOOL_TRUE] @172:55
                     matches [KW_MATCHES] @172:84
                        b-guest.first-name [FIELD_CHAR] @172:65
                        + [PLUS] @172:98
                           g-f-n [VAR_CHAR] @172:92
                           "*" [STRING] @172:100
               ( [LPARENS] @173:22
                  if [FUNC_POLY] @173:23
                     or [KW_OR] @173:36
                        = [EQUALS] @173:32
                           g-l-n [VAR_CHAR] @173:26
                           ? [UNKNOWN_VAL] @173:34
                        = [EQUALS] @173:45
                           g-l-n [VAR_CHAR] @173:39
                           "" [STRING] @173:47
                     true [BOOL_TRUE] @173:55
                     matches [KW_MATCHES] @173:83
                        b-guest.last-name [FIELD_CHAR] @173:65
                        + [PLUS] @173:97
                           g-l-n [VAR_CHAR] @173:91
                           "*" [STRING] @173:99
            ( [LPARENS] @174:22
               if [FUNC_POLY] @174:23
                  = [EQUALS] @174:32
                     g-dob [VAR_DATE] @174:26
                     ? [UNKNOWN_VAL] @174:34
                  true [BOOL_TRUE] @174:41
                  = [EQUALS] @174:73
                     b-guest.date-of-birth [FIELD_DATE] @174:51
                     g-dob [VAR_DATE] @174:75
   use-index [KW_USE_IDX] @174:82
      idx-g-id [INDEX] @174:92
   no-lock [KW_NO_LOCK] @174:101
   no-error [KW_NO_ERROR] @174:109
./abl/guests.p 00208 00056
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @208:29
   use-index [KW_USE_IDX] @208:37
      idx-g-id [INDEX] @208:47
   no-lock [KW_NO_LOCK] @208:56
   no-error [KW_NO_ERROR] @208:64
./abl/guests.p 00273 00049
record phrase [RECORD_PHRASE] @0:0
   guest [TABLE] @273:15
   where [KW_WHERE] @273:21
      expression [EXPRESSION] @0:0
         = [EQUALS] @273:42
            guest.guest-id [FIELD_INT] @273:27
            g-id [VAR_INT] @273:44
   no-lock [KW_NO_LOCK] @273:49
   no-error [KW_NO_ERROR] @273:57
./abl/rates-report.p 00112 00016
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
./abl/rates-report.p 00155 00016
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
./abl/rates-report.p 00260 00016
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
./abl/rates-report.p 00303 00016
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
./abl/rates.p 00167 00036
record phrase [RECORD_PHRASE] @0:0
   b-rate [BUFFER] @164:17
   where [KW_WHERE] @165:10
      expression [EXPRESSION] @0:0
         and [KW_AND] @165:42
            = [EQUALS] @165:29
               b-rate.floor [FIELD_INT] @165:16
               rate.floor [FIELD_INT] @165:31
            = [EQUALS] @166:36
               b-rate.type-of-room [FIELD_INT] @166:16
               rate.type-of-room [FIELD_INT] @166:38
   use-index [KW_USE_IDX] @167:10
      idx-rate-s-date [INDEX] @167:20
   no-lock [KW_NO_LOCK] @167:36
   no-error [KW_NO_ERROR] @167:44
./abl/reservations.p 00089 00074
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @88:27
   where [KW_WHERE] @89:4
      expression [EXPRESSION] @0:0
         <> [NOT_EQ] @89:67
            reservation.state [FIELD_CHAR] @89:49
            'C' [STRING] @89:70
   no-lock [KW_NO_LOCK] @89:74
   use-index [KW_USE_IDX] @89:82
      idx-r-checkin [INDEX] @89:92
./abl/reservations.p 00099 00061
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @99:9
   where [KW_WHERE] @99:21
      expression [EXPRESSION] @0:0
         = [EQUALS] @99:54
            reservation.reservation-id [FIELD_INT] @99:27
            r-id [VAR_INT] @99:56
   no-lock [KW_NO_LOCK] @99:61
   no-error [KW_NO_ERROR] @99:69
./abl/reservations.p 00106 00055
record phrase [RECORD_PHRASE] @0:0
   b-res [BUFFER] @106:9
   where [KW_WHERE] @106:15
      expression [EXPRESSION] @0:0
         = [EQUALS] @106:34
            recid [FUNC_RECID] @106:21
               b-res [BUFFER] @106:27
            recid [FUNC_RECID] @106:36
               reservation [TABLE] @106:42
   no-lock [KW_NO_LOCK] @106:55
   no-error [KW_NO_ERROR] @106:63
./abl/reservations.p 00115 00047
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @115:9
   where [KW_WHERE] @115:17
      expression [EXPRESSION] @0:0
         = [EQUALS] @115:40
            b-guest.guest-id [FIELD_INT] @115:23
            g-id [VAR_INT] @115:42
   no-lock [KW_NO_LOCK] @115:47
   no-error [KW_NO_ERROR] @115:55
./abl/reservations.p 00191 00076
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 00224 00053
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @224:26
   use-index [KW_USE_IDX] @224:34
      idx-g-id [INDEX] @224:44
   no-lock [KW_NO_LOCK] @224:53
   no-error [KW_NO_ERROR] @224:61
./abl/reservations.p 00273 00050
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @273:12
   where [KW_WHERE] @273:20
      expression [EXPRESSION] @0:0
         = [EQUALS] @273:43
            b-guest.guest-id [FIELD_INT] @273:26
            g-id [VAR_INT] @273:45
   no-lock [KW_NO_LOCK] @273:50
./abl/reservations.p 00394 00082
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
./abl/reservations.p 00405 00067
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @405:15
   where [KW_WHERE] @405:27
      expression [EXPRESSION] @0:0
         = [EQUALS] @405:60
            reservation.reservation-id [FIELD_INT] @405:33
            r-id [VAR_INT] @405:62
   no-lock [KW_NO_LOCK] @405:67
   no-error [KW_NO_ERROR] @405:75
./abl/reservations.p 00428 00051
record phrase [RECORD_PHRASE] @0:0
   b-res [BUFFER] @428:26
   use-index [KW_USE_IDX] @428:32
      idx-r-id [INDEX] @428:42
   no-lock [KW_NO_LOCK] @428:51
   no-error [KW_NO_ERROR] @428:59
./abl/reservations.p 00482 00062
record phrase [RECORD_PHRASE] @0:0
   b-guest [BUFFER] @482:24
   where [KW_WHERE] @482:32
      expression [EXPRESSION] @0:0
         = [EQUALS] @482:55
            b-guest.guest-id [FIELD_INT] @482:38
            g-id [VAR_INT] @482:57
   no-lock [KW_NO_LOCK] @482:62
   no-error [KW_NO_ERROR] @482:70
./abl/reservations.p 00519 00068
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 00525 00077
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 00554 00067
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @554:15
   where [KW_WHERE] @554:27
      expression [EXPRESSION] @0:0
         = [EQUALS] @554:60
            reservation.reservation-id [FIELD_INT] @554:33
            r-id [VAR_INT] @554:62
   no-lock [KW_NO_LOCK] @554:67
   no-error [KW_NO_ERROR] @554:75
./abl/reservations.p 00613 00113
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
./abl/reservations.p 00618 00025
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 00643 00051
record phrase [RECORD_PHRASE] @0:0
   b-rate [BUFFER] @640:32
   where [KW_WHERE] @641:25
      expression [EXPRESSION] @0:0
         and [KW_AND] @642:58
            and [KW_AND] @641:73
               = [EQUALS] @641:51
                  b-rate.type-of-room [FIELD_INT] @641:31
                  b-room.type-of-room [FIELD_INT] @641:53
               <= [LTE] @642:49
                  b-rate.start-date [FIELD_DATE] @642:31
                  today [FUNC_DATE] @642:52
            ( [LPARENS] @642:62
               or [KW_OR] @642:83
                  = [EQUALS] @642:79
                     b-rate.end-date [FIELD_DATE] @642:63
                     ? [UNKNOWN_VAL] @642:81
                  >= [GTE] @642:102
                     b-rate.end-date [FIELD_DATE] @642:86
                     today [FUNC_DATE] @642:105
   use-index [KW_USE_IDX] @643:25
      idx-rate-e-date [INDEX] @643:35
   no-lock [KW_NO_LOCK] @643:51
   no-error [KW_NO_ERROR] @643:59
./abl/reservations.p 00649 00054
record phrase [RECORD_PHRASE] @0:0
   b-rate [BUFFER] @646:35
   where [KW_WHERE] @647:28
      expression [EXPRESSION] @0:0
         and [KW_AND] @647:76
            = [EQUALS] @647:54
               b-rate.type-of-room [FIELD_INT] @647:34
               b-room.type-of-room [FIELD_INT] @647:56
            <= [LTE] @648:50
               b-rate.end-date [FIELD_DATE] @648:34
               today [FUNC_DATE] @648:53
   use-index [KW_USE_IDX] @649:28
      idx-rate-e-date [INDEX] @649:38
   no-lock [KW_NO_LOCK] @649:54
   no-error [KW_NO_ERROR] @649:62
./abl/reservations.p 00674 00067
record phrase [RECORD_PHRASE] @0:0
   reservation [TABLE] @674:15
   where [KW_WHERE] @674:27
      expression [EXPRESSION] @0:0
         = [EQUALS] @674:60
            reservation.reservation-id [FIELD_INT] @674:33
            r-id [VAR_INT] @674:62
   no-lock [KW_NO_LOCK] @674:67
./abl/rooms-add.p 00063 00081
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @63:12
   where [KW_WHERE] @63:17
      expression [EXPRESSION] @0:0
         and [KW_AND] @63:53
            = [EQUALS] @63:34
               room.floor [FIELD_INT] @63:23
               current-floor-no [VAR_INT] @63:36
            = [EQUALS] @63:74
               room.room-number [FIELD_INT] @63:57
               r-no [VAR_INT] @63:76
   no-lock [KW_NO_LOCK] @63:81
   no-error [KW_NO_ERROR] @63:89
./abl/rooms.p 00038 00053
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @38:12
   where [KW_WHERE] @38:17
      expression [EXPRESSION] @0:0
         = [EQUALS] @38:34
            room.floor [FIELD_INT] @38:23
            current-floor-no [VAR_INT] @38:36
   no-lock [KW_NO_LOCK] @38:53
   use-index [KW_USE_IDX] @38:61
      idx-r-no [INDEX] @38:71
   no-error [KW_NO_ERROR] @38:80
./abl/rooms.p 00069 00045
record phrase [RECORD_PHRASE] @0:0
   b-room [BUFFER] @69:9
   where [KW_WHERE] @69:16
      expression [EXPRESSION] @0:0
         = [EQUALS] @69:36
            recid [FUNC_RECID] @69:22
               b-room [BUFFER] @69:28
            c-room [VAR_RECID] @69:38
   no-lock [KW_NO_LOCK] @69:45
./abl/rooms.p 00075 00110
record phrase [RECORD_PHRASE] @0:0
   room-state [TABLE] @75:14
   where [KW_WHERE] @75:25
      expression [EXPRESSION] @0:0
         and [KW_AND] @75:75
            = [EQUALS] @75:54
               room-state.room-number [FIELD_INT] @75:31
               b-room.room-number [FIELD_INT] @75:56
            <= [LTE] @75:101
               room-state.start-date [FIELD_DATE] @75:79
               today [FUNC_DATE] @75:104
   no-lock [KW_NO_LOCK] @75:110
   no-error [KW_NO_ERROR] @75:118
./abl/rooms.p 00113 00061
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @113:20
   where [KW_WHERE] @113:25
      expression [EXPRESSION] @0:0
         = [EQUALS] @113:42
            room.floor [FIELD_INT] @113:31
            current-floor-no [VAR_INT] @113:44
   no-lock [KW_NO_LOCK] @113:61
   use-index [KW_USE_IDX] @113:69
      idx-r-no [INDEX] @113:79
   no-error [KW_NO_ERROR] @113:88
./abl/rooms.p 00120 00061
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @120:20
   where [KW_WHERE] @120:25
      expression [EXPRESSION] @0:0
         = [EQUALS] @120:42
            room.floor [FIELD_INT] @120:31
            current-floor-no [VAR_INT] @120:44
   no-lock [KW_NO_LOCK] @120:61
   use-index [KW_USE_IDX] @120:69
      idx-r-no [INDEX] @120:79
   no-error [KW_NO_ERROR] @120:88
./abl/rooms.p 00127 00062
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @127:21
   where [KW_WHERE] @127:26
      expression [EXPRESSION] @0:0
         = [EQUALS] @127:43
            room.floor [FIELD_INT] @127:32
            current-floor-no [VAR_INT] @127:45
   no-lock [KW_NO_LOCK] @127:62
   use-index [KW_USE_IDX] @127:70
      idx-r-no [INDEX] @127:80
   no-error [KW_NO_ERROR] @127:89
./abl/rooms.p 00134 00061
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @134:20
   where [KW_WHERE] @134:25
      expression [EXPRESSION] @0:0
         = [EQUALS] @134:42
            room.floor [FIELD_INT] @134:31
            current-floor-no [VAR_INT] @134:44
   no-lock [KW_NO_LOCK] @134:61
   use-index [KW_USE_IDX] @134:69
      idx-r-no [INDEX] @134:79
   no-error [KW_NO_ERROR] @134:88
./abl/rooms.p 00148 00051
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @148:15
   where [KW_WHERE] @148:20
      expression [EXPRESSION] @0:0
         = [EQUALS] @148:43
            room.room-number [FIELD_INT] @148:26
            r-no2 [VAR_INT] @148:45
   no-lock [KW_NO_LOCK] @148:51
   no-error [KW_NO_ERROR] @148:59
./abl/rooms.p 00159 00079
record phrase [RECORD_PHRASE] @0:0
   b-room-state2 [BUFFER] @159:18
   where [KW_WHERE] @159:32
      expression [EXPRESSION] @0:0
         = [EQUALS] @159:57
            b-room-state2.room [FIELD_INT] @159:38
            b-room2.room-number [FIELD_INT] @159:59
   no-lock [KW_NO_LOCK] @159:79
   no-error [KW_NO_ERROR] @159:87
./abl/rooms.p 00188 00080
record phrase [RECORD_PHRASE] @0:0
   b-room-state2 [BUFFER] @188:19
   where [KW_WHERE] @188:33
      expression [EXPRESSION] @0:0
         = [EQUALS] @188:58
            b-room-state2.room [FIELD_INT] @188:39
            b-room2.room-number [FIELD_INT] @188:60
   no-lock [KW_NO_LOCK] @188:80
   no-error [KW_NO_ERROR] @188:88
./abl/rooms.p 00221 00062
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @221:21
   where [KW_WHERE] @221:26
      expression [EXPRESSION] @0:0
         = [EQUALS] @221:43
            room.floor [FIELD_INT] @221:32
            current-floor-no [VAR_INT] @221:45
   no-lock [KW_NO_LOCK] @221:62
   use-index [KW_USE_IDX] @221:70
      idx-r-no [INDEX] @221:80
   no-error [KW_NO_ERROR] @221:89
./abl/rooms.p 00234 00062
record phrase [RECORD_PHRASE] @0:0
   room [TABLE] @234:21
   where [KW_WHERE] @234:26
      expression [EXPRESSION] @0:0
         = [EQUALS] @234:43
            room.floor [FIELD_INT] @234:32
            current-floor-no [VAR_INT] @234:45
   no-lock [KW_NO_LOCK] @234:62
   use-index [KW_USE_IDX] @234:70
      idx-r-no [INDEX] @234:80
   no-error [KW_NO_ERROR] @234:89

Conditions matched: [ type == prog.kw_sh_lock or type == prog.kw_exc_lock or type == prog.kw_no_lock ]


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