Hello Guys,
I had written a query approval that whenever the Delivery Doctotal is Less than the Customer Commitment it should promt to approval.
Error is "Could not commit transaction. Error -1 detected during transaction (RDR1).
Both query i did below are giving me error.
1.
SELECT distinct 'True' from ODLN where $[$29.0.Number] < $[OCRD."DebtLine"]
2.
SELECT distinct 'True' FROM ODLN T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode" where $[$29.0.Number] < $[OCRD."DebtLine"]
Please help me solve this problem.
Thanks a lot.