./abl/add-rooms-dialog.w.cache: (hotel.room - PRIMARY index selected) 03254 FIND FIRST room WHERE room.room-num = i NO-ERROR. ./abl/avail-rooms-frame.w.cache: (hotel.room-type - PRIMARY index selected) 04106 FOR EACH room-type: (hotel.room-type - PRIMARY index selected) 04295 IF CAN-FIND(room-type WHERE room-type.room-type = rt) THEN (hotel.reservation - PRIMARY index selected) 04349 FOR EACH reservation NO-LOCK 04350 WHERE NOT (reservation.end-date <= date1 OR date2 <= reservation.start-date): (hotel.stay - PRIMARY index selected) 04360 FOR EACH stay NO-LOCK 04361 WHERE NOT (stay.end-date <= date1 OR date2 <= stay.start-date): (hotel.room - PRIMARY index selected) 04370 OPEN QUERY availRooms FOR EACH room NO-LOCK WHERE room.ACTIVE 04371 AND (IF r-type <> 0 THEN room.room-type = r-type ELSE TRUE) 04372 AND LOOKUP(STRING(room.room-num), busy-reserv) = 0 04373 AND LOOKUP(STRING(room.room-num), busy-stay) = 0, (hotel.room-type - PRIMARY index selected) 04370 OPEN QUERY availRooms FOR EACH room NO-LOCK WHERE room.ACTIVE 04371 AND (IF r-type <> 0 THEN room.room-type = r-type ELSE TRUE) 04372 AND LOOKUP(STRING(room.room-num), busy-reserv) = 0 04373 AND LOOKUP(STRING(room.room-num), busy-stay) = 0, 04374 EACH room-type OF room NO-LOCK. ./abl/common/adecomm/as-utils.w.cache: (appsrv-tt - PRIMARY index selected) 00267 IF CAN-FIND(FIRST AppSrv-TT) THEN (appsrv-tt - PRIMARY index selected) 00310 FIND FIRST AppSrv-TT WHERE AppSrv-TT.Partition = partition_name NO-ERROR. (appsrv-tt - PRIMARY index selected) 00358 FOR EACH xAppSrv-TT WHERE xAppSrv-TT.AS-Handle = conn-hdl: /* make sure any other references to this handle */ (appsrv-tt - PRIMARY index selected) 00432 FIND FIRST AppSrv-TT WHERE AppSrv-TT.Partition = partition_name NO-ERROR. (appsrv-tt - PRIMARY index selected) 00522 FOR EACH AppSrv-TT NO-LOCK: (appsrv-tt - PRIMARY index selected) 00699 FIND FIRST lAppSrvTT WHERE lAppSrvTT.Partition = cPartition NO-ERROR. ./abl/common/adm2/containr.p.cache: (tttranslate - PRIMARY index selected) 05270 FOR EACH ttTranslate: ./abl/common/adm2/data.p.cache: (ttschema - PRIMARY index selected) 04162 FOR EACH ttSchema WHERE INDEX_position = "":U: ./abl/common/adm2/smart.p.cache: (admlink - NO index selected) 02502 OPEN QUERY BROWSE-1 FOR EACH ADMLink BY IF Radio-Sort = "Type":U THEN linkType ELSE IF Radio-Sort = "Source":U THEN linkSource:file-name ELSE linkTarget:file-name. (admlink - NO index selected) 02512 OPEN QUERY BROWSE-1 FOR EACH ADMLink BY IF Radio-Sort = "Type":U THEN linkType ELSE IF Radio-Sort = "Source":U THEN linkSource:file-name ELSE linkTarget:file-name. ./abl/common/adm2/viewer.p.cache: (ttlookupcopy - PRIMARY index selected) 02566 FOR EACH ttLookupCopy: (ttdcombocopy - PRIMARY index selected) 02571 FOR EACH ttDComboCopy: (ttcombodata - PRIMARY index selected) 03252 IF VALID-HANDLE(gshAstraAppserver) AND CAN-FIND(FIRST ttComboData) THEN ./abl/ehotel.p.cache: (hotel.room - PRIMARY index selected) 00102 for each room no-lock: (hotel.reservation - PRIMARY index selected) 00107 for each reservation 00108 where reservation.start-date <= end-date 00109 and reservation.end-date > start-date 00110 no-lock: (tt-rooms-used - PRIMARY index selected) 00117 if not can-find(tt-rooms-used 00118 where tt-rooms-used.use-date = next-date 00119 and tt-rooms-used.room-num = reservation.room-num) then (hotel.stay - PRIMARY index selected) 00132 for each stay 00133 where stay.start-date <= end-date 00134 and stay.end-date > start-date 00135 no-lock: (tt-rooms-used - PRIMARY index selected) 00142 if not can-find(tt-rooms-used 00143 where tt-rooms-used.use-date = next-date 00144 and tt-rooms-used.room-num = stay.room-num) then (hotel.room-type - PRIMARY index selected) 00251 for each room-type no-lock, (hotel.room - PRIMARY index selected) 00251 for each room-type no-lock, 00252 each room no-lock 00253 where room.room-type = room-type.room-type 00254 and room.active (tt-room-type-agg - PRIMARY index selected) 00275 for each tt-room-type-agg, (hotel.rate - PRIMARY index selected) 00275 for each tt-room-type-agg, 00276 each rate no-lock 00277 where rate.room-type = tt-room-type-agg.room-type 00278 and rate.start-date <= end-date 00279 and rate.end-date >= start-date: (hotel.room - PRIMARY index selected) 00292 for each room no-lock 00293 where room.active, (hotel.reservation - PRIMARY index selected) 00292 for each room no-lock 00293 where room.active, 00294 each reservation no-lock 00295 where reservation.room-num = room.room-num 00296 and reservation.start-date <= end-date 00297 and reservation.end-date > start-date: (hotel.rate - PRIMARY index selected) 00307 find first rate 00308 where rate.room-type = room.room-type 00309 and rate.start-date <= next-date 00310 and rate.end-date >= next-date 00311 no-lock no-error. (hotel.room - PRIMARY index selected) 00328 for each room no-lock 00329 where room.active, (hotel.stay - PRIMARY index selected) 00328 for each room no-lock 00329 where room.active, 00330 each stay no-lock 00331 where stay.room-num = room.room-num 00332 and stay.start-date <= end-date 00333 and stay.end-date > start-date: (hotel.rate - PRIMARY index selected) 00343 find first rate 00344 where rate.room-type = room.room-type 00345 and rate.start-date <= next-date 00346 and rate.end-date >= next-date 00347 no-lock no-error. (tt-room-type-agg - PRIMARY index selected) 00364 for each tt-room-type-agg: ./abl/export-data.p.cache: (hotel._file - PRIMARY index selected) 00102 for each _file where _file._owner = "PUB" and not _file._file-name begins "_" no-lock: ./abl/fwd-embedded-driver.p.cache: (fwd-embedded-window - NO index selected) 00186 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (fwd-embedded-window - NO index selected) 00239 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (fwd-embedded-window - NO index selected) 00249 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (fwd-embedded-window - NO index selected) 00273 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (fwd-embedded-window - NO index selected) 00313 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (page-toolbar - NO index selected) 00331 if not can-find(page-toolbar where page-toolbar.pname = lastWindow and 00332 page-toolbar.pnum = lastPage and page-toolbar.button = h) (fwd-embedded-window - NO index selected) 00364 find first fwd-embedded-window where fwd-embedded-window.pname = lastWindow no-error. (page-toolbar - NO index selected) 00367 for each page-toolbar where page-toolbar.pname = lastWindow: (fwd-embedded-window - NO index selected) 00456 find first fwd-embedded-window where fwd-embedded-window.pname = windowProgram no-error. (fwd-embedded-window - NO index selected) 00530 find first fwd-embedded-window where fwd-embedded-window.pname = pfile no-error. (page-toolbar - NO index selected) 00739 for each page-toolbar where page-toolbar.pnum = pnum and page-toolbar.pname = lastWindow: ./abl/guests-frame.w.cache: (hotel.service - PRIMARY index selected) 04076 FOR EACH xservice WHERE xservice.stay-id = stay.stay-id: (hotel.guest - PRIMARY index selected) 04079 FOR EACH xguest WHERE xguest.stay-id = stay.stay-id: (hotel.stay - PRIMARY index selected) 04082 FIND CURRENT stay EXCLUSIVE-LOCK. (hotel.stay - PRIMARY index selected) 04248 OPEN QUERY staysBrowse FOR EACH stay WHERE stay.checked-out = FALSE NO-LOCK, EACH room OF stay NO-LOCK, EACH room-type OF room NO-LOCK, EACH guest OF stay WHERE guest.order = 1 NO-LOCK. (hotel.room - PRIMARY index selected) 04248 OPEN QUERY staysBrowse FOR EACH stay WHERE stay.checked-out = FALSE NO-LOCK, EACH room OF stay NO-LOCK, EACH room-type OF room NO-LOCK, EACH guest OF stay WHERE guest.order = 1 NO-LOCK. (hotel.room-type - PRIMARY index selected) 04248 OPEN QUERY staysBrowse FOR EACH stay WHERE stay.checked-out = FALSE NO-LOCK, EACH room OF stay NO-LOCK, EACH room-type OF room NO-LOCK, EACH guest OF stay WHERE guest.order = 1 NO-LOCK. (hotel.guest - PRIMARY index selected) 04248 OPEN QUERY staysBrowse FOR EACH stay WHERE stay.checked-out = FALSE NO-LOCK, EACH room OF stay NO-LOCK, EACH room-type OF room NO-LOCK, EACH guest OF stay WHERE guest.order = 1 NO-LOCK. (hotel.stay - PRIMARY index selected) 04278 OPEN QUERY staysBrowse FOR 04279 EACH stay WHERE 04280 (IF roomNum <> ? THEN stay.room-num = roomNum ELSE TRUE) AND 04281 (IF past THEN TRUE ELSE stay.checked-out = FALSE) 04282 NO-LOCK, (hotel.room - PRIMARY index selected) 04278 OPEN QUERY staysBrowse FOR 04279 EACH stay WHERE 04280 (IF roomNum <> ? THEN stay.room-num = roomNum ELSE TRUE) AND 04281 (IF past THEN TRUE ELSE stay.checked-out = FALSE) 04282 NO-LOCK, 04283 EACH room OF stay NO-LOCK, (hotel.room-type - PRIMARY index selected) 04278 OPEN QUERY staysBrowse FOR 04279 EACH stay WHERE 04280 (IF roomNum <> ? THEN stay.room-num = roomNum ELSE TRUE) AND 04281 (IF past THEN TRUE ELSE stay.checked-out = FALSE) 04282 NO-LOCK, 04283 EACH room OF stay NO-LOCK, 04284 EACH room-type OF room NO-LOCK, (hotel.guest - PRIMARY index selected) 04278 OPEN QUERY staysBrowse FOR 04279 EACH stay WHERE 04280 (IF roomNum <> ? THEN stay.room-num = roomNum ELSE TRUE) AND 04281 (IF past THEN TRUE ELSE stay.checked-out = FALSE) 04282 NO-LOCK, 04283 EACH room OF stay NO-LOCK, 04284 EACH room-type OF room NO-LOCK, 04285 EACH guest OF stay WHERE 04286 guest.order = 1 AND 04287 (IF guestName <> ? THEN 04288 guest.first-name + " " + guest.last-name MATCHES guestName ELSE TRUE) 04289 NO-LOCK. ./abl/rates-frame.w.cache: (hotel.room-type - PRIMARY index selected) 03975 FIND FIRST xroom-type WHERE xroom-type.room-type = rate.room-type. (hotel.rate - PRIMARY index selected) 03985 FIND CURRENT rate EXCLUSIVE-LOCK. (hotel.rate - PRIMARY index selected) 04104 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK, EACH room-type OF rate NO-LOCK. (hotel.room-type - PRIMARY index selected) 04104 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK, EACH room-type OF rate NO-LOCK. (hotel.rate - PRIMARY index selected) 04141 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK, (hotel.room-type - PRIMARY index selected) 04141 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK, 04142 EACH room-type OF rate NO-LOCK. (hotel.rate - PRIMARY index selected) 04145 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK 04146 WHERE rate.end-date >= TODAY, (hotel.room-type - PRIMARY index selected) 04145 OPEN QUERY ratesBrowse FOR EACH rate NO-LOCK 04146 WHERE rate.end-date >= TODAY, 04147 EACH room-type OF rate NO-LOCK. (hotel.room-type - PRIMARY index selected) 04165 FIND room-type WHERE room-type.room-type = rate.room-type. ./abl/reservations-frame.w.cache: (hotel.reservation - PRIMARY index selected) 04049 FIND CURRENT reservation EXCLUSIVE-LOCK. (hotel.reservation - PRIMARY index selected) 04194 OPEN QUERY reservationsBrowse FOR EACH reservation WHERE reservation.end-date >= today NO-LOCK, EACH room OF reservation NO-LOCK, EACH room-type OF room NO-LOCK. (hotel.room - PRIMARY index selected) 04194 OPEN QUERY reservationsBrowse FOR EACH reservation WHERE reservation.end-date >= today NO-LOCK, EACH room OF reservation NO-LOCK, EACH room-type OF room NO-LOCK. (hotel.room-type - PRIMARY index selected) 04194 OPEN QUERY reservationsBrowse FOR EACH reservation WHERE reservation.end-date >= today NO-LOCK, EACH room OF reservation NO-LOCK, EACH room-type OF room NO-LOCK. (hotel.reservation - PRIMARY index selected) 04222 OPEN QUERY reservationsBrowse FOR EACH reservation 04223 WHERE reservation.end-date >= today 04224 AND (IF roomNum <> ? THEN reservation.room-num = roomNum ELSE TRUE) 04225 AND (IF guest <> ? THEN reservation.guest MATCHES guest ELSE TRUE) 04226 NO-LOCK, (hotel.room - PRIMARY index selected) 04222 OPEN QUERY reservationsBrowse FOR EACH reservation 04223 WHERE reservation.end-date >= today 04224 AND (IF roomNum <> ? THEN reservation.room-num = roomNum ELSE TRUE) 04225 AND (IF guest <> ? THEN reservation.guest MATCHES guest ELSE TRUE) 04226 NO-LOCK, 04227 EACH hotel.room OF hotel.reservation NO-LOCK, (hotel.room-type - PRIMARY index selected) 04222 OPEN QUERY reservationsBrowse FOR EACH reservation 04223 WHERE reservation.end-date >= today 04224 AND (IF roomNum <> ? THEN reservation.room-num = roomNum ELSE TRUE) 04225 AND (IF guest <> ? THEN reservation.guest MATCHES guest ELSE TRUE) 04226 NO-LOCK, 04227 EACH hotel.room OF hotel.reservation NO-LOCK, 04228 EACH hotel.room-type OF hotel.room NO-LOCK. ./abl/rooms-frame.w.cache: (hotel.room - PRIMARY index selected) 03265 FIND xroom EXCLUSIVE-LOCK WHERE xroom.room-num = room.room-num. (number - NO index selected) 03320 FOR EACH number: (hotel.room - PRIMARY index selected) 03321 FIND room WHERE room.room-num = number.num. (hotel.room - PRIMARY index selected) 03462 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, EACH room-type OF room NO-LOCK. (hotel.room-type - PRIMARY index selected) 03462 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, EACH room-type OF room NO-LOCK. (hotel.room - PRIMARY index selected) 03480 FIND FIRST xroom WHERE xroom.room-num = findRoomNum NO-ERROR. (hotel.room - PRIMARY index selected) 03516 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, (hotel.room-type - PRIMARY index selected) 03516 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, 03517 EACH room-type OF hotel.room NO-LOCK 03518 WHERE room.floor = val. (hotel.room - PRIMARY index selected) 03521 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, (hotel.room-type - PRIMARY index selected) 03521 OPEN QUERY roomsBrowse FOR EACH room NO-LOCK, 03522 EACH room-type OF room NO-LOCK. (hotel.room - PRIMARY index selected) 03539 FOR EACH xroom NO-LOCK BREAK BY xroom.floor: ./abl/update-guest-dialog.w.cache: (hotel.guest-id-type - PRIMARY index selected) 04027 FOR EACH guest-id-type: (hotel.guest - PRIMARY index selected) 04041 FIND LAST guest WHERE guest.stay-id = stay-id NO-ERROR. (hotel.guest - PRIMARY index selected) 04056 FIND guest WHERE rowid(guest) = recordRid. (hotel.guest - PRIMARY index selected) 04062 FIND guest WHERE rowid(guest) = recordRid. ./abl/update-rate-dialog.w.cache: (hotel.rate - PRIMARY index selected) 03943 FIND FIRST xrate WHERE xrate.room-type = rt AND 03944 NOT ((xrate.end-date < startDate:INPUT-VALUE AND 03945 xrate.start-date < startDate:INPUT-VALUE) OR 03946 (xrate.end-date > endDate:INPUT-VALUE AND 03947 xrate.start-date > endDate:INPUT-VALUE)) AND 03948 (IF recordRid <> ? THEN rowid(xrate) <> recordRid 03949 ELSE TRUE) NO-ERROR. (hotel.rate - PRIMARY index selected) 03965 FIND rate WHERE ROWID(rate) = recordRid. (hotel.room-type - PRIMARY index selected) 04023 FOR EACH room-type: (hotel.rate - PRIMARY index selected) 04045 FIND rate WHERE ROWID(rate) = recordRid. ./abl/update-reservation-dialog.w.cache: (hotel.reservation - PRIMARY index selected) 03977 FIND FIRST xreservation NO-LOCK 03978 WHERE xreservation.room-num = num AND 03979 NOT (xreservation.end-date <= date1 OR date2 <= xreservation.start-date) and 03980 (IF recordRid <> ? THEN ROWID(xreservation) <> recordRid ELSE TRUE) NO-ERROR. (hotel.reservation - PRIMARY index selected) 03989 for each xreservation NO-LOCK 03990 WHERE xreservation.room-num = num AND 03991 NOT (xreservation.end-date <= date1 OR date2 <= xreservation.start-date): (hotel.stay - PRIMARY index selected) 04001 FIND FIRST xstay NO-LOCK 04002 WHERE xstay.room-num = num AND 04003 NOT (xstay.end-date <= date1 OR date2 <= xstay.start-date) and 04004 (IF NOT isReservation AND recordRid <> ? THEN 04005 ROWID(xstay) <> recordRid ELSE TRUE) 04006 NO-ERROR. (hotel.reservation - PRIMARY index selected) 04020 FIND reservation WHERE ROWID(reservation) = recordRid. (hotel.rate - PRIMARY index selected) 04148 FOR EACH rate WHERE rate.room-type = room-type AND 04149 NOT ((rate.start-date < date1 AND rate.end-date < date1) OR 04150 (rate.start-date >= date2 AND rate.end-date >= date2)) (hotel.room - PRIMARY index selected) 04191 FIND FIRST room WHERE room.room-num = num NO-ERROR. (hotel.room - PRIMARY index selected) 04256 FOR EACH room: (hotel.reservation - PRIMARY index selected) 04273 FIND reservation WHERE ROWID(reservation) = recordRid. (hotel.room - PRIMARY index selected) 04417 FIND FIRST room WHERE room.room-num = num NO-ERROR. (hotel.room-type - PRIMARY index selected) 04423 FIND room-type WHERE room-type.room-type = room.room-type. ./abl/update-room-dialog.w.cache: (hotel.room - PRIMARY index selected) 03229 FIND room WHERE room.room-num = inRoomNum. (hotel.room - PRIMARY index selected) 03246 FIND room NO-LOCK WHERE room.room-num = inRoomNum. ./abl/update-service-dialog.w.cache: (hotel.service-type - PRIMARY index selected) 03966 FIND FIRST service-type WHERE service-type.service-type = val NO-ERROR. (hotel.service-type - PRIMARY index selected) 03988 FOR EACH service-type: (hotel.service - PRIMARY index selected) 04009 FIND service WHERE rowid(service) = recordRid. ./abl/update-stay-dialog.w.cache: (hotel.guest - PRIMARY index selected) 04126 FIND FIRST guest WHERE guest.stay-id = stay.stay-id NO-ERROR. (hotel.reservation - PRIMARY index selected) 04155 FIND FIRST xreservation NO-LOCK 04156 WHERE xreservation.room-num = num AND 04157 NOT (xreservation.end-date <= date1 OR date2 <= xreservation.start-date) and 04158 (IF recordRid <> ? THEN ROWID(xreservation) <> recordRid ELSE TRUE) NO-ERROR. (hotel.reservation - PRIMARY index selected) 04167 for each xreservation NO-LOCK 04168 WHERE xreservation.room-num = num AND 04169 NOT (xreservation.end-date <= date1 OR date2 <= xreservation.start-date): (hotel.stay - PRIMARY index selected) 04179 FIND FIRST xstay NO-LOCK 04180 WHERE xstay.room-num = num AND 04181 NOT (xstay.end-date <= date1 OR date2 <= xstay.start-date) and 04182 (IF NOT isReservation AND recordRid <> ? THEN 04183 ROWID(xstay) <> recordRid ELSE TRUE) 04184 NO-ERROR. (hotel.guest - PRIMARY index selected) 04200 FOR EACH xguest WHERE xguest.stay-id = stay.stay-id NO-LOCK: (hotel.guest - PRIMARY index selected) 04232 FIND CURRENT guest EXCLUSIVE-LOCK. (hotel.guest - PRIMARY index selected) 04238 FOR EACH xguest WHERE xguest.stay-id = stay.stay-id: (hotel.service - PRIMARY index selected) 04268 FIND CURRENT service EXCLUSIVE-LOCK. (hotel.rate - PRIMARY index selected) 04461 FOR EACH rate WHERE rate.room-type = room-type AND 04462 NOT ((rate.start-date < date1 AND rate.end-date < date1) OR 04463 (rate.start-date >= date2 AND rate.end-date >= date2)) (hotel.room - PRIMARY index selected) 04504 FIND FIRST room WHERE room.room-num = num NO-ERROR. (hotel.room - PRIMARY index selected) 04569 FOR EACH room: (hotel.stay - PRIMARY index selected) 04582 FIND LAST xstay NO-ERROR. (hotel.stay - PRIMARY index selected) 04618 FIND stay WHERE ROWID(stay) = recordRid. (hotel.guest - PRIMARY index selected) 04805 OPEN QUERY guests FOR EACH guest WHERE guest.stay-id = stay.stay-id NO-LOCK. (hotel.service - PRIMARY index selected) 04820 FOR EACH xservice WHERE xservice.stay-id = stay.stay-id: (hotel.service - PRIMARY index selected) 04829 OPEN QUERY services FOR EACH service NO-LOCK 04830 WHERE service.stay-id = stay.stay-id, (hotel.service-type - PRIMARY index selected) 04829 OPEN QUERY services FOR EACH service NO-LOCK 04830 WHERE service.stay-id = stay.stay-id, 04831 EACH service-type OF service NO-LOCK. (hotel.room - PRIMARY index selected) 04872 FIND FIRST room WHERE room.room-num = num NO-ERROR. (hotel.room-type - PRIMARY index selected) 04877 FIND room-type WHERE room-type.room-type = room.room-type.