아래 SQL명령이 IBExpert와 Delphi 7에서는 문제없이 실행되는데
Delphi 2007 Win 32 + dbExpress의 TSQLQuery 또는 TSQLDataSet에서
"..... Token unknown - line 13, column 19 ?." 라는 Error 메세지가 뜹니다.
환장하겠습니다.
무슨 문제인지 살펴주십시오.
SELECT X.*, D."AAA"
FROM
(
SELECT "CODE', "GUBOON",
SUM(IIF("PAY_GB"=1 AND "SER_NO">0, 1, 0)) AS "A",
SUM(IIF("PAY_GB"=1 AND "SER_NO">0, "AMT", 0)) AS "B",
SUM(IIF("PAY_GB"=1 AND "SER_NO"<0, 1, 0)) AS "C",
SUM(IIF("PAY_GB"=1 AND "SER_NO"<0, "AMT", 0)) AS "D",
SUM(IIF("PAY_GB"=0 AND "SER_NO">0, 1, 0)) AS "E",
SUM(IIF("PAY_GB"=0 AND "SER_NO">0, "AMT", 0)) AS "F",
SUM(IIF("SER_NO" < 0, 1, 0)) AS "G",
SUM(IIF("SER_NO" < 0, "AMT", 0)) AS "H",
SUM(IIF("R_DATE" > "S_DATE", "AMT", 0)) AS "K",
SUM(IIF("SER_NO"<0 AND "R_DATE" > "S_DATE", "AMT", 0)) AS "L"
FROM "SALE"
WHERE ("S_DATE" = :pDate) AND ("DAM" = :pDam)
GROUP BY "CODE", "GUBOON"
) X
LEFT JOIN "CUSTOM" D ON D."CODE" = X."CODE"
|