FIND FIRST (7 in 3 files)

Filename Line # Column # Match Text
./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/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/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 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 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

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.