find [KW_FIND] (50 in 6 files)

Filename Line # Column # Match Text
./abl/checkout.p 00138 00007
find [KW_FIND] @138:7
   record phrase [RECORD_PHRASE] @0:0
      room [TABLE] @138:12
      where [KW_WHERE] @138:17
         expression [EXPRESSION] @0:0
            = [EQUALS] @138:40
               room.room-number [FIELD_INT] @138:23
               checkout-room.room-number [FIELD_INT] @138:42
./abl/checkout.p 00149 00010
find [KW_FIND] @149:10
   first [KW_FIRST] @149:15
   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 00016
find [KW_FIND] @273:16
   first [KW_FIRST] @273:21
   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 00304 00013
find [KW_FIND] @304:13
   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 00013
find [KW_FIND] @305:13
   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 00013
find [KW_FIND] @310:13
   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/checkout.p 00322 00016
find [KW_FIND] @322:16
   record phrase [RECORD_PHRASE] @0:0
      b-room [BUFFER] @322:21
      where [KW_WHERE] @322:28
         expression [EXPRESSION] @0:0
            = [EQUALS] @322:53
               b-room.room-number [FIELD_INT] @322:34
               b-out-room.room-number [FIELD_INT] @322:55
./abl/checkout.p 00332 00013
find [KW_FIND] @332:13
   record phrase [RECORD_PHRASE] @0:0
      b-checkout [BUFFER] @332:18
      where [KW_WHERE] @332:29
         expression [EXPRESSION] @0:0
            = [EQUALS] @332:53
               recid [FUNC_RECID] @332:35
                  b-checkout [BUFFER] @332:41
               recid [FUNC_RECID] @332:55
                  checkout [TABLE] @332:61
      exclusive-lock [KW_EXC_LOCK] @332:71
./abl/checkout.p 00342 00010
find [KW_FIND] @342:10
   current [KW_CURRENT] @342:15
   record phrase [RECORD_PHRASE] @0:0
      checkout [TABLE] @342:23
./abl/checkout.p 00343 00010
find [KW_FIND] @343:10
   current [KW_CURRENT] @343:15
   record phrase [RECORD_PHRASE] @0:0
      room [TABLE] @343:23
./abl/guests.p 00171 00013
find [KW_FIND] @171:13
   first [KW_FIRST] @171:18
   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 00193 00013
find [KW_FIND] @193:13
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @193:18
      where [KW_WHERE] @193:26
         expression [EXPRESSION] @0:0
            = [EQUALS] @193:49
               b-guest.guest-id [FIELD_INT] @193:32
               guest.guest-id [FIELD_INT] @193:51
      exclusive-lock [KW_EXC_LOCK] @193:66
./abl/guests.p 00208 00019
find [KW_FIND] @208:19
   last [KW_LAST] @208:24
   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 00010
find [KW_FIND] @273:10
   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/guests.p 00284 00013
find [KW_FIND] @284:13
   record phrase [RECORD_PHRASE] @0:0
      b-guest [BUFFER] @284:18
      where [KW_WHERE] @284:26
         expression [EXPRESSION] @0:0
            = [EQUALS] @284:49
               b-guest.guest-id [FIELD_INT] @284:32
               guest.guest-id [FIELD_INT] @284:51
      exclusive-lock [KW_EXC_LOCK] @284:66
./abl/rates.p 00164 00007
find [KW_FIND] @164:7
   last [KW_LAST] @164:12
   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/rates.p 00225 00007
find [KW_FIND] @225:7
   record phrase [RECORD_PHRASE] @0:0
      b-rate [BUFFER] @225:12
      where [KW_WHERE] @225:19
         expression [EXPRESSION] @0:0
            = [EQUALS] @225:39
               recid [FUNC_RECID] @225:25
                  b-rate [BUFFER] @225:31
               recid [FUNC_RECID] @225:41
                  rate [TABLE] @225:47
      exclusive-lock [KW_EXC_LOCK] @225:53
./abl/reservations.p 00099 00004
find [KW_FIND] @99:4
   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 00004
find [KW_FIND] @106:4
   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 00004
find [KW_FIND] @115:4
   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 00224 00016
find [KW_FIND] @224:16
   last [KW_LAST] @224:21
   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 00007
find [KW_FIND] @273:7
   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 00405 00010
find [KW_FIND] @405:10
   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 00016
find [KW_FIND] @428:16
   last [KW_LAST] @428:21
   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 00019
find [KW_FIND] @482:19
   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 00554 00010
find [KW_FIND] @554:10
   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 00575 00013
find [KW_FIND] @575:13
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @575:18
      where [KW_WHERE] @575:24
         expression [EXPRESSION] @0:0
            = [EQUALS] @575:51
               b-res.reservation-id [FIELD_INT] @575:30
               r-id [VAR_INT] @575:53
      exclusive-lock [KW_EXC_LOCK] @575:58
./abl/reservations.p 00640 00022
find [KW_FIND] @640:22
   last [KW_LAST] @640:27
   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 00646 00025
find [KW_FIND] @646:25
   last [KW_LAST] @646:30
   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 00010
find [KW_FIND] @674:10
   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/reservations.p 00684 00016
find [KW_FIND] @684:16
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @684:21
      where [KW_WHERE] @684:27
         expression [EXPRESSION] @0:0
            = [EQUALS] @684:54
               b-res.reservation-id [FIELD_INT] @684:33
               r-id [VAR_INT] @684:56
      exclusive-lock [KW_EXC_LOCK] @684:61
./abl/reservations.p 00699 00013
find [KW_FIND] @699:13
   record phrase [RECORD_PHRASE] @0:0
      b-res [BUFFER] @699:18
      where [KW_WHERE] @699:24
         expression [EXPRESSION] @0:0
            = [EQUALS] @699:51
               b-res.reservation-id [FIELD_INT] @699:30
               r-id [VAR_INT] @699:53
      exclusive-lock [KW_EXC_LOCK] @699:58
./abl/rooms-add.p 00063 00007
find [KW_FIND] @63:7
   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 00001
find [KW_FIND] @38:1
   first [KW_FIRST] @38:6
   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 00004
find [KW_FIND] @69:4
   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 00004
find [KW_FIND] @75:4
   last [KW_LAST] @75:9
   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 00010
find [KW_FIND] @113:10
   prev [KW_PREV] @113:15
   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 00010
find [KW_FIND] @120:10
   next [KW_NEXT] @120:15
   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 00010
find [KW_FIND] @127:10
   first [KW_FIRST] @127:15
   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 00010
find [KW_FIND] @134:10
   last [KW_LAST] @134:15
   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 00010
find [KW_FIND] @148:10
   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 00157 00013
find [KW_FIND] @157:13
   record phrase [RECORD_PHRASE] @0:0
      b-room2 [BUFFER] @157:18
      where [KW_WHERE] @157:26
         expression [EXPRESSION] @0:0
            = [EQUALS] @157:47
               recid [FUNC_RECID] @157:32
                  b-room2 [BUFFER] @157:38
               c-room [VAR_RECID] @157:49
./abl/rooms.p 00159 00013
find [KW_FIND] @159:13
   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 00169 00022
find [KW_FIND] @169:22
   current [KW_CURRENT] @169:27
   record phrase [RECORD_PHRASE] @0:0
      b-room-state2 [BUFFER] @169:35
      exclusive-lock [KW_EXC_LOCK] @169:49
./abl/rooms.p 00186 00013
find [KW_FIND] @186:13
   record phrase [RECORD_PHRASE] @0:0
      b-room2 [BUFFER] @186:18
      where [KW_WHERE] @186:26
         expression [EXPRESSION] @0:0
            = [EQUALS] @186:47
               recid [FUNC_RECID] @186:32
                  b-room2 [BUFFER] @186:38
               c-room [VAR_RECID] @186:49
./abl/rooms.p 00188 00013
find [KW_FIND] @188:13
   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 00198 00022
find [KW_FIND] @198:22
   current [KW_CURRENT] @198:27
   record phrase [RECORD_PHRASE] @0:0
      b-room-state2 [BUFFER] @198:35
      exclusive-lock [KW_EXC_LOCK] @198:49
./abl/rooms.p 00221 00010
find [KW_FIND] @221:10
   first [KW_FIRST] @221:15
   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 00010
find [KW_FIND] @234:10
   first [KW_FIRST] @234:15
   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
./abl/rooms.p 00247 00013
find [KW_FIND] @247:13
   record phrase [RECORD_PHRASE] @0:0
      b-room2 [BUFFER] @247:18
      where [KW_WHERE] @247:26
         expression [EXPRESSION] @0:0
            = [EQUALS] @247:47
               recid [FUNC_RECID] @247:32
                  b-room2 [BUFFER] @247:38
               c-room [VAR_RECID] @247:49
      exclusive-lock [KW_EXC_LOCK] @247:56

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


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