-
Shin Jungi
- PowerServer 2020 or older (Obsolete)
- Friday, 29 March 2024 07:30 AM UTC
[APPEON WEB] Inquiry about the cause of the warning message
1. When running locally, no error or warning message appears.
An error occurred in the attached image when distributing APPEON WEB.
It is a simple SQL statement, but in APPEON WEB, if the format of the number part does not match, this message appears once in a while, and even though the format is correct, the warning message continues to appear. Only this data window occurs.
After the warning window, you can view it normally.
[reference]
What part of the SQL statement should I change?
Even if I change almost every part, the same warning window appears.
SELECT
A.I_ORDER AS I_ORDER;
D.N_CUSTOM_PROJ AS N_CUSTOM_PROJ;
D.C_MAT AS C_ITEM;
A.C_MAT AS C_MAT;
B.N_MAT AS N_MAT,
B.N_SIZE AS N_SIZE;
B.C_GRADE AS C_GRADE,
C.C_LOCATION AS C_LOCATION,
C.C_STORE AS C_STORE,
CAST(A.Q_IN_QTY AS decimal) AS Q_IN_QTY;
CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal) AS Q_OUT_QTY;
CASE
WHEN CAST(A.Q_IN_QTY AS decimal) - CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal) > 0 THEN CAST(A.Q_IN_QTY AS decimal) - CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal)
ELSE 0
END AS Q_INV;
A.I_FIELD
FROM
(SELECT
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT;
CAST(SUM(Q_QTY) AS decimal) AS Q_IN_QTY
FROM
TBL_I_INOUT (NOLOCK)
WHERE
F_INOUT = 'I'
GROUP BY
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT)A
LEFT JOIN
(SELECT
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT;
CAST(SUM(Q_QTY) AS decimal) AS Q_OUT_QTY
FROM
TBL_I_INOUT (NOLOCK)
WHERE
F_INOUT = 'O'
GROUP BY
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT) AA
ON
A.I_FIELD = AA.I_FIELD
AND A.I_ORDER = AA.I_ORDER
AND A.C_MAT = AA.C_MAT
JOIN
TBL_B_MAT B (NOLOCK)
ON
A.C_MAT = B.C_MAT
JOIN
TBL_I_INOUT C (NOLOCK)
ON
A.I_FIELD = C.I_FIELD
AND A.I_ORDER = C.I_ORDER
AND A.C_MAT = C.C_MAT
AND A.I_INOUT = C.I_INOUT
JOIN
V_ORDER_ALL D (NOLOCK)
ON
C.I_FIELD = D.I_FIELD
AND C.I_ORDER = D.I_ORDER
AND C.S_ORDER = D.S_ORDER
WHERE
CAST((A.Q_IN_QTY - ISNULL(AA.Q_OUT_QTY, 0)) AS decimal) > 0
AND A.I_FIELD = :as_field
AND D.N_CUSTOM_PROJ LIKE :as_custom
AND A.I_ORDER LIKE :as_order
AND A.C_MAT LIKE :as_item
AND B.C_GROUP LIKE :as_group
AND A.C_MAT like :as_mat
AND B.N_MAT LIKE :as_nmat
AND ISNULL(B.N_SIZE,'') LIKE :as_size
AND ISNULL(B.N_SIZE,'') LIKE :as_size2
AND ISNULL(B.N_SIZE,'') LIKE :as_size3
AND C.C_LOCATION LIKE :as_location
attached image
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.