定義了一個string變數 SQL_Query，用來存盤SQL陳述句，Formatted了一下，大概200行左右，算上空格 7000多字符，然后編譯時就出現了這個錯誤，
但是減少SQL陳述句就可以編譯成功，在別人電腦上編譯也不會報這個錯，這是為什么？
查了百度和CSDN都沒有類似的錯誤，請各位遇到過這種錯誤的前輩指點一下。
//第一部分 主資料
SQL_Query = @"SELECT DISTINCT
SUBCON_ID,
P_OPER,
CXMT_LOT_ID,
PRODUCT_ID,
LOT_ID,
HIST_SEQ,
(CASE
WHEN SUBSTR (PRODUCT_ID, 1, 2) = 'DB' THEN 'FBGA'
WHEN SUBSTR (PRODUCT_ID, 1, 2) = 'DQ' THEN 'WBGA'
ELSE ' '
END)
AS PROD_TYPE,
WO_NO,
OPERATION_NO,
STEP_NAME,
WEEK,
SUBSTR (SLT_END_TIME, 0, 10)
AS TEST_DATE,
NVL (S_TIME_ST, S_TIME_SP) || '.00'
AS SLT_START_TIME,
SLT_END_TIME || '.00'
AS SLT_END_TIME,
TEST_TYPE,
(SELECT TEST_TEMP
FROM MWIPTSTPGM
WHERE OPER = P_OLD_OPER
AND MAT_ID = P_MAT_ID
AND RELEASE_FLAG = 'Y'
AND TEST_PGM_VER = P_TEST_PGM_VER
AND TEST_PGM_NAME = P_TEST_PGM_NAME)
AS TEST_TEMP,
DECODE (TRIM (P_TEST_PGM_NAME || P_TEST_PGM_VER),
NULL, '',
TRIM (P_TEST_PGM_NAME || '_' || P_TEST_PGM_VER))
AS PROGRAM,
NVL (
(SELECT TEST_TIME
FROM MWIPTSTPGM
WHERE OPER = P_OLD_OPER
AND MAT_ID = P_MAT_ID
AND RELEASE_FLAG = 'Y'
AND TEST_PGM_VER = P_TEST_PGM_VER
AND TEST_PGM_NAME = P_TEST_PGM_NAME),
0)
AS TEST_TIME,
EQP_ID,
QTY,
END_CUST,
LOT_TYPE,
DECODE (TRIM (F_TEST_PGM_NAME || F_TEST_PGM_VER),
NULL, '',
TRIM (F_TEST_PGM_NAME || '_' || F_TEST_PGM_VER))
AS FT_TEST_PGM
FROM (SELECT DISTINCT
'HFTF'
AS SUBCON_ID,
HIS.OLD_OPER
AS P_OPER,
HIS.MAT_ID
AS P_MAT_ID,
HIS.OLD_OPER
AS P_OLD_OPER,
ELT.CUST_LOT_ID
AS CXMT_LOT_ID,
HIS.LOT_CMF_5
AS PRODUCT_ID,
HIS.LOT_ID
AS LOT_ID,
HIS.HIST_SEQ
AS HIST_SEQ,
(SELECT WO_NUMBER
FROM EDI_812_EWO
WHERE WO_NUMBER = ELT.CUST_DATA_2
AND SHIP_LOT_ID = ELT.CUST_DATA_1)
AS WO_NO,
(SELECT KEY_5
FROM MGCMTBLDAT
WHERE TABLE_NAME = 'OPER_TEST' AND KEY_6 = HIS.OLD_OPER)
AS OPERATION_NO,
(SELECT KEY_3
FROM MGCMTBLDAT
WHERE TABLE_NAME = 'OPER_TEST' AND KEY_6 = HIS.OLD_OPER)
AS STEP_NAME,
ELT.WORK_WEEK
AS WEEK,
(SELECT TO_CHAR (
TO_DATE (MAX (TRAN_TIME), 'YYYY/MM/DD HH24:MI:SS'),
'YYYY/MM/DD HH24:MI:SS')
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = HIS.OLD_OPER
AND HIST_DEL_FLAG <> 'Y'
AND TRAN_CODE = 'START')
AS S_TIME_ST,
(SELECT TO_CHAR (
TO_DATE (MAX (TRAN_TIME), 'YYYY/MM/DD HH24:MI:SS'),
'YYYY/MM/DD HH24:MI:SS')
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = HIS.OLD_OPER
AND FROM_TO_FLAG = 'T'
AND HIST_DEL_FLAG <> 'Y'
AND TRAN_CODE = 'SPLIT')
AS S_TIME_SP,
(SELECT TO_CHAR (
TO_DATE (MAX (TRAN_TIME), 'YYYY/MM/DD HH24:MI:SS'),
'YYYY/MM/DD HH24:MI:SS')
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = HIS.OLD_OPER
AND HIST_DEL_FLAG <> 'Y'
AND TRAN_CODE = 'END')
AS SLT_END_TIME,
(CASE WHEN HIS.OLD_OPER = '6061' THEN '1' ELSE '2' END)
AS TEST_TYPE,
(SELECT TRAN_CMF_4
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = HIS.OLD_OPER
AND TRAN_CODE = 'START'
AND HIST_DEL_FLAG <> 'Y')
AS P_TEST_PGM_VER,
(SELECT TRAN_CMF_7
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = HIS.OLD_OPER
AND TRAN_CODE = 'START'
AND HIST_DEL_FLAG <> 'Y')
AS P_TEST_PGM_NAME,
HIS.START_RES_ID
AS EQP_ID,
HIS.QTY_3
AS QTY,
(SELECT CMF_4
FROM EDI_812_EWO
WHERE WO_NUMBER = ELT.CUST_DATA_2
AND SHIP_LOT_ID = ELT.CUST_DATA_1)
AS END_CUST,
(SELECT LOT_TYPE
FROM EDI_812_EWO
WHERE WO_NUMBER = ELT.CUST_DATA_2
AND SHIP_LOT_ID = ELT.CUST_DATA_1)
AS LOT_TYPE,
(SELECT TRAN_CMF_4
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = '6062'
AND TRAN_CODE = 'START'
AND HIST_DEL_FLAG <> 'Y')
AS F_TEST_PGM_VER,
(SELECT TRAN_CMF_7
FROM MWIPLOTHIS
WHERE LOT_ID = HIS.LOT_ID
AND OLD_OPER = '6062'
AND TRAN_CODE = 'START'
AND HIST_DEL_FLAG <> 'Y')
AS F_TEST_PGM_NAME
FROM MWIPLOTHIS HIS, MWIPLOTSTS STS, MWIPELTSTS ELT
WHERE HIS.LOT_ID = STS.LOT_ID
AND HIS.LOT_ID = ELT.LOT_ID
AND HIS.TRAN_TIME > :S_TIME
AND HIS.TRAN_TIME < :E_TIME
AND HIS.TRAN_CODE = 'LOTBDC'
AND HIS.FACTORY = 'TEST'
AND HIS.LOT_CMF_2 = '812'
AND HIS.OLD_OPER IN ('6062', '6061')
AND HIS.HIST_DEL_FLAG <> 'Y')
ORDER BY TEST_DATE";
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/214454.html
標籤：C#
上一篇：求一個加密碼方法。C#