Error in Query Approval (Doctotal < DebitLimit)

[former_member351438]

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.

[former_member351438 · Accepted solution]

I guess this answer my question.

SELECT distinct 'True' from ODLN where CAST ($[ODLN."DocTotal"] as DECIMAL) < $[OCRD."DebtLine"]