Filename
|
Line #
|
Column #
|
Match Text
|
./abl/checkout.p |
00083 |
00001 |
open [OPEN_QUERY] @83:1
q-checkout [QUERY] @83:12
for [KW_FOR] @84:4
each [KW_EACH] @84:8
record phrase [RECORD_PHRASE] @0:0
checkout [TABLE] @84:13
no-lock [KW_NO_LOCK] @84:22
each [KW_EACH] @85:8
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 |
00093 |
00004 |
open [OPEN_QUERY] @93:4
q-room [QUERY] @93:15
for [KW_FOR] @94:7
each [KW_EACH] @94:11
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/guests.p |
00085 |
00001 |
open [OPEN_QUERY] @85:1
q-guest [QUERY] @85:12
for [KW_FOR] @85:20
each [KW_EACH] @85:24
record phrase [RECORD_PHRASE] @0:0
guest [TABLE] @85:29
use-index [KW_USE_IDX] @85:35
idx-g-id [INDEX] @85:45
|
./abl/rates.p |
00100 |
00004 |
open [OPEN_QUERY] @100:4
q-room [QUERY] @100:15
for [KW_FOR] @101:7
each [KW_EACH] @101:11
record phrase [RECORD_PHRASE] @0:0
t-floor [TEMP_TABLE] @101:16
where [KW_WHERE] @101:24
expression [EXPRESSION] @0:0
( [LPARENS] @101:30
if [FUNC_POLY] @101:31
= [EQUALS] @101:51
current-floor-no [VAR_INT] @101:34
? [UNKNOWN_VAL] @101:53
true [BOOL_TRUE] @101:60
= [EQUALS] @101:84
t-floor.floor [FIELD_INT] @101:70
current-floor-no [VAR_INT] @101:86
each [KW_EACH] @102:10
record phrase [RECORD_PHRASE] @0:0
t-room-type [TEMP_TABLE] @102:15
where [KW_WHERE] @102:27
expression [EXPRESSION] @0:0
( [LPARENS] @102:33
if [FUNC_POLY] @102:34
= [EQUALS] @102:55
current-room-type [VAR_INT] @102:37
? [UNKNOWN_VAL] @102:57
true [BOOL_TRUE] @102:64
= [EQUALS] @102:91
t-room-type.type [FIELD_INT] @102:74
current-room-type [VAR_INT] @102:93
each [KW_EACH] @103:10
record phrase [RECORD_PHRASE] @0:0
rate [TABLE] @103:15
where [KW_WHERE] @103:20
expression [EXPRESSION] @0:0
and [KW_AND] @103:53
= [EQUALS] @103:37
rate.floor [FIELD_INT] @103:26
t-floor.floor [FIELD_INT] @103:39
= [EQUALS] @104:44
rate.type-of-room [FIELD_INT] @104:26
t-room-type.type [FIELD_INT] @104:46
outer-join [KW_OUT_JOIN] @105:20
use-index [KW_USE_IDX] @106:20
idx-rate-e-date [INDEX] @106:30
|
./abl/reservations.p |
00088 |
00001 |
open [OPEN_QUERY] @88:1
q-res [QUERY] @88:12
for [KW_FOR] @88:18
each [KW_EACH] @88:22
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 |
00206 |
00010 |
open [OPEN_QUERY] @206:10
q-guest [QUERY] @206:21
for [KW_FOR] @206:29
each [KW_EACH] @206:33
record phrase [RECORD_PHRASE] @0:0
b-guest [BUFFER] @206:38
where [KW_WHERE] @207:13
expression [EXPRESSION] @0:0
and [KW_AND] @208:98
and [KW_AND] @207:102
( [LPARENS] @207:19
if [FUNC_POLY] @207:20
or [KW_OR] @207:33
= [EQUALS] @207:29
g-f-n [VAR_CHAR] @207:23
? [UNKNOWN_VAL] @207:31
= [EQUALS] @207:42
g-f-n [VAR_CHAR] @207:36
"" [STRING] @207:44
true [BOOL_TRUE] @207:52
matches [KW_MATCHES] @207:81
b-guest.first-name [FIELD_CHAR] @207:62
+ [PLUS] @207:95
g-f-n [VAR_CHAR] @207:89
"*" [STRING] @207:97
( [LPARENS] @208:16
if [FUNC_POLY] @208:17
or [KW_OR] @208:30
= [EQUALS] @208:26
g-l-n [VAR_CHAR] @208:20
? [UNKNOWN_VAL] @208:28
= [EQUALS] @208:39
g-l-n [VAR_CHAR] @208:33
"" [STRING] @208:41
true [BOOL_TRUE] @208:49
matches [KW_MATCHES] @208:77
b-guest.last-name [FIELD_CHAR] @208:59
+ [PLUS] @208:91
g-l-n [VAR_CHAR] @208:85
"*" [STRING] @208:93
( [LPARENS] @209:16
if [FUNC_POLY] @209:17
= [EQUALS] @209:26
g-dob [VAR_DATE] @209:20
? [UNKNOWN_VAL] @209:28
true [BOOL_TRUE] @209:35
= [EQUALS] @209:67
b-guest.date-of-birth [FIELD_DATE] @209:45
g-dob [VAR_DATE] @209:69
|
./abl/reservations.p |
00601 |
00019 |
open [OPEN_QUERY] @601:19
q-rs-room [QUERY] @601:30
for [KW_FOR] @602:22
each [KW_EACH] @602:26
record phrase [RECORD_PHRASE] @0:0
b-room [BUFFER] @602:31
where [KW_WHERE] @602:38
expression [EXPRESSION] @0:0
= [EQUALS] @602:64
b-room.type-of-room [FIELD_INT] @602:44
b-res-room.type-of-room [FIELD_INT] @602:66
|