PrJlndni
Member
Good day everyone,
I would like to ask your help regarding my troubles in debugging my program.
Below is my syntax. Whenever the program collects a lot of data, this error Lock table overflow, increase -L on server (915) appeared. What are your suggested solution to this? Thank you very much for your help.
t_HeadTitle02 = string(t_DateFrom) + " to " + string(t_DateTo) + " with " + string(cb_Description) + " and " + string(cb_AcctType).
DISPLAY t_HeadTitle02 WITH FRAME f_MainProc.
FOR EACH CustService.CustTrans WHERE (CustService.CustTrans.Transac-Date GE t_DateFrom AND CustService.CustTrans.Transac-Date LE t_DateTo), EACH CustService.Customer WHERE CustService.Customer.RecAddrs = CustService.CustTrans.RecAddrs, EACH CustService.LU_TransactionCodes WHERE (CustService.LU_TransactionCodes.trans-code-1 = CustService.CustTrans.Trans-Code-1 AND CustService.LU_TransactionCodes.trans-code-2 = CustService.CustTrans.Trans-Code-2) NO-LOCK.
t_counter = t_counter + 1.
t_total = t_total + CustService.CustTrans.Amount.
END.
ENABLE t_QryCustTrans1 WITH FRAME f_QryCustTrans1. OPEN QUERY t_QryCustTrans1 FOR EACH CustService.CustTrans WHERE (CustService.CustTrans.Transac-Date GE t_DateFrom AND CustService.CustTrans.Transac-Date LE t_DateTo), EACH CustService.Customer WHERE CustService.Customer.RecAddrs = CustService.CustTrans.RecAddrs, EACH CustService.LU_TransactionCodes WHERE (CustService.LU_TransactionCodes.trans-code-1 = CustService.CustTrans.Trans-Code-1 AND CustService.LU_TransactionCodes.trans-code-2 = CustService.CustTrans.Trans-Code-2) BY CustService.CustTrans.Transac-Date.
WAIT-FOR F4, F9, F3 OF t_QryCustTrans1 IN FRAME f_QryCustTrans1 FOCUS t_QryCustTrans1.
I would like to ask your help regarding my troubles in debugging my program.
Below is my syntax. Whenever the program collects a lot of data, this error Lock table overflow, increase -L on server (915) appeared. What are your suggested solution to this? Thank you very much for your help.
t_HeadTitle02 = string(t_DateFrom) + " to " + string(t_DateTo) + " with " + string(cb_Description) + " and " + string(cb_AcctType).
DISPLAY t_HeadTitle02 WITH FRAME f_MainProc.
FOR EACH CustService.CustTrans WHERE (CustService.CustTrans.Transac-Date GE t_DateFrom AND CustService.CustTrans.Transac-Date LE t_DateTo), EACH CustService.Customer WHERE CustService.Customer.RecAddrs = CustService.CustTrans.RecAddrs, EACH CustService.LU_TransactionCodes WHERE (CustService.LU_TransactionCodes.trans-code-1 = CustService.CustTrans.Trans-Code-1 AND CustService.LU_TransactionCodes.trans-code-2 = CustService.CustTrans.Trans-Code-2) NO-LOCK.
t_counter = t_counter + 1.
t_total = t_total + CustService.CustTrans.Amount.
END.
ENABLE t_QryCustTrans1 WITH FRAME f_QryCustTrans1. OPEN QUERY t_QryCustTrans1 FOR EACH CustService.CustTrans WHERE (CustService.CustTrans.Transac-Date GE t_DateFrom AND CustService.CustTrans.Transac-Date LE t_DateTo), EACH CustService.Customer WHERE CustService.Customer.RecAddrs = CustService.CustTrans.RecAddrs, EACH CustService.LU_TransactionCodes WHERE (CustService.LU_TransactionCodes.trans-code-1 = CustService.CustTrans.Trans-Code-1 AND CustService.LU_TransactionCodes.trans-code-2 = CustService.CustTrans.Trans-Code-2) BY CustService.CustTrans.Transac-Date.
WAIT-FOR F4, F9, F3 OF t_QryCustTrans1 IN FRAME f_QryCustTrans1 FOCUS t_QryCustTrans1.
Last edited by a moderator: