請問各位大大...我想用下面這種方式動態更改SQL裡面的字串...但string型態好像存不下...= =|||，會告訴我超過255個字，請問該如何解決?

<textarea class="delphi" rows="10" cols="60" name="code"><br />
var STR : String

STR :=SELECT STNID,SUM(CASE CNUM WHEN '02' THEN nspoil ELSE 0 END) AS nspo2,
SUM(CASE CNUM WHEN '03' THEN nspoil ELSE 0 END) AS nspo3,
SUM(CASE CNUM WHEN '04' THEN nspoil ELSE 0 END) AS nspo4,
SUM(CASE CNUM WHEN '05' THEN nspoil ELSE 0 END) AS nspo5,
SUM(CASE CNUM WHEN '02' THEN nspmey ELSE 0 END) AS nspm2,
SUM(CASE CNUM WHEN '03' THEN nspmey ELSE 0 END) AS nspm3,
SUM(CASE CNUM WHEN '04' THEN nspmey ELSE 0 END) AS nspm4,
SUM(CASE CNUM WHEN '05' THEN nspmey ELSE 0 END) AS nspm5,
SUM(nspoil) AS nsptalo,
SUM(nspmey) AS nsptalm
FROM (SELECT STATION.STNID,OIL_MCH.CNUM,SUM(VAL_O - VAL_TEST) AS nspoil,SUM(FMEY_TAL) AS nspmey FROM STATION LEFT JOIN OIL_MCH ON OIL_MCH.STNID = STATION.STNID AND PDATE = '20070508' AND CLSS = '2' GROUP BY STATION.STNID,OIL_MCH.CNUM) AS a GROUP BY STNID ORDER BY STNID ;

ADOQuery1.Close;
ADOQuery1.SQL.ADD(STR);
ADOQuery1.Open;
</textarea>

編輯記錄

我碰到過這種問題，不是STRING型態的問題，STRING可以存2G的資料哪可能存不下！是ADOQUERY！
解決方法很簡單，把你的SQL字串拆成數段，然後一次次的ADD上去。
ADOQUERY1.SQL.ADD('第一段');
ADOQUERY1.SQL.ADD('第二段');
ADOQUERY1.SQL.ADD('第三段');
...

Delphi 的 String 預設為 AnsiString ，容量最大可到 2GB ，所以和String是沒關係的，我實地用你的範例試了一下，發現你語法最後一行長度大於 255 ，如果把那一行拆成二行就 OK 了，你趕緊試一下吧。

------
--Written by max