SQL字串問題... |
答題得分者是:pcjung
|
7-11
一般會員 發表:53 回覆:33 積分:16 註冊:2005-12-05 發送簡訊給我 |
請問各位大大...我想用下面這種方式動態更改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> |
Stallion
版主 發表:52 回覆:1600 積分:1995 註冊:2004-09-15 發送簡訊給我 |
|
pcjung
一般會員 發表:1 回覆:17 積分:13 註冊:2002-11-21 發送簡訊給我 |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |