Rauf
VIP Member
How can a specify a range in Select Table IO ?
I just tried the following code and it works nice. But performance will degrade if there are too much records.
In the code below, I just calculate the total hours worked by a labor during a period.
Any other ways to achieve the same ?
I just tried the following code and it works nice. But performance will degrade if there are too much records.
In the code below, I just calculate the total hours worked by a labor during a period.
Any other ways to achieve the same ?
Code:
Listing of ER for Named ER: N59RM01
=======================================================================
NAMED ER: Get Labor Hours Summary
=======================================================================
evt_HR
evt_OT
evt_HR_Total
evt_OT_Total
evt_EmployeeCardJDate
0001 //
0002 //
0003 F59RM03.Select
BF mnLaborID = TK RM Labor ID
BF jdTimesheetDateFROM <= TK Emp Card Date - Julian
0004 F59RM03.Fetch Next
VA evt_EmployeeCardJDate <- TK Emp Card Date - Julian
0005 While SV File_IO_Status is equal to CO SUCCESS And VA evt_EmployeeCardJDate is less than or equal to BF jdTimesheetDateTO
0006 // Calculate ...
0007 End While
Wednesday September 10, 2014 10:18
Last edited: