VFP 愛用者社區

[an1060]

以前在VFP6.0上撰寫的SELECT-SQL 之GROUP BY沒問題,但到了VFP8.0就全都多掛了.
一直不知是何因,不知諸位是是也倍感困擾,
終於于今日發現可以正常運作的方式了
-----------------------------------------------
SELECT kind, SUM(amt) AS amt, count(kind) AS ac, unit_no FROM payout GROUP BY kind, unit_no INTO CURSOR prttemp........正常

SELECT SUM(amt) AS amt, count(kind) AS ac, kind, unit_no FROM payout GROUP BY kind, unit_no INTO CURSOR prttemp.......正常

SELECT SUM(amt) AS amt, count(kind) AS ac, kind FROM payout GROUP BY kind INTO CURSOR prttemp.......正常

SELECT SUM(amt) AS amt, count(kind) AS ac, kind, unit_no FROM payout GROUP BY kind INTO CURSOR prttemp.......不正常

------------------
看出端倪了嗎?
也就是除了要SUM(), COUNT(),...以外的欄位,只能有GROUP BY的欄位,其餘的只要加進來,一定會出現1807之錯誤.

這應該說是VFP6.0較鬆散,VFP8.0較嚴謹

[elleryq]

這個以前有人問過了~~
麻煩搜尋一下先~

[Ruey]

正確SQL語法應該這麼下達:

[yannick]

對啊!!這個GROUP BY的特殊寫法，還讓我感到迷糊了好久呢~
不過，這樣想想，這種所謂「不正常」的寫法，比較好用ㄟ！