08:30:26  Program Started at : 4/8/2017 8:30:26 Logged in by:SEC
08:32:36 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4035' AND tbJobExpireLocationByRoom.sFloor = '' AND ('083236' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
08:32:42 Save Job:insert into tbJobMaster (nJobID, dtAddedDate, sAddedBy, nStatus, sRoomNo, sExtNo, sGuestCode, sJobType, sGuestName,  nAssignType, sAssignToDept, sAssignToUser, sRemarks, nIsNew, sNotifyUsers, sAddedUserDept,sJobCode,sCourtesy,Duration,dtNextExpire,sMobileNo,sOther,sQty,nPicture) values ( 27436,'2017-08-04 08:32:42.000','SEC', 1,'PA338','PA338','CommonArea','004',N'',1,'-','-',N'G/F #5 Staircase G¼Ó5¸¹«á¼Ó±è-1xCeiling light fused ¤Ñªá¿O¿N  ',1,'','Security','4035',0,60,'2017-08-04 09:32:42.000','-','','1',0)
08:33:53  Program Exit at : 4/8/2017 8:33:53
08:59:53  Program Started at : 4/8/2017 8:59:53 Logged in by:SEC
09:02:36  Program Exit at : 4/8/2017 9:02:36
09:14:16  Program Started at : 4/8/2017 9:14:16 Logged in by:SEC
09:16:59 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4024' AND tbJobExpireLocationByRoom.sFloor = '' AND ('091659' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
09:17:05 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4054' AND tbJobExpireLocationByRoom.sFloor = '' AND ('091705' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
09:22:42 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4003' AND tbJobExpireLocationByRoom.sFloor = '' AND ('092242' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
09:23:06 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4003' AND tbJobExpireLocationByRoom.sFloor = '' AND ('092306' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
09:23:06    frmNewJob                	cboCode_KeyPress(KeyAscii As Integer) : 	91-Object variable or With block variable not set
09:23:07 SELECT tbPagingGroup.sPagerNo, tbPagingGroup.sCallingNo, tbPagingGroup.sPagingName FROM (tbJobExpireLocationByRoom LEFT Outer JOIN tbCallPath ON tbJobExpireLocationByRoom.sPath=tbCallPath.sPath) INNER JOIN tbPagingGroup ON tbCallPath.sPagerNo=tbPagingGroup.sPagerNo where tbCallPath.nLevel = 0 AND tbJobExpireLocationByRoom.sJobCode = '4003' AND tbJobExpireLocationByRoom.sFloor = '' AND ('092307' BETWEEN tbCallPath.dtStartTime AND tbCallPath.dtEndTime) order by tbCallPath.dtStartTime
09:23:07    frmNewJob                	cboCode_KeyPress(KeyAscii As Integer) : 	91-Object variable or With block variable not set
09:24:19  Program Exit at : 4/8/2017 9:24:19
12:56:15  Program Started at : 4/8/2017 12:56:15 Logged in by:SEC
