rajesh4you
New Member
Hi All,
I have a requirment to find date of the first instance of the Inventory, lot location being added. For this my logic is as below:
FOR EACH ld_det:
FOR FIRST tr_hist NO-LOCK WHERE tr_serial = ld_lot
AND tr_loc = ld_loc
AND tr_part = ld_part
BY tr_date :
ASSIGN
v-date = tr_date.END. /*FOR FIRST tr_hist */
END. /*FOR EACH ld_det*/
It is taking more time. Please help in fine tuning the code if required or any way to make the query run fast?
Please help.
I have a requirment to find date of the first instance of the Inventory, lot location being added. For this my logic is as below:
FOR EACH ld_det:
FOR FIRST tr_hist NO-LOCK WHERE tr_serial = ld_lot
AND tr_loc = ld_loc
AND tr_part = ld_part
BY tr_date :
ASSIGN
v-date = tr_date.END. /*FOR FIRST tr_hist */
END. /*FOR EACH ld_det*/
It is taking more time. Please help in fine tuning the code if required or any way to make the query run fast?
Please help.