VFP 愛用者社區

[TSAISUN]

大俠們請幫忙
下列這段在vfp6執行正常，在vfp9就會掛掉，請問哪裡錯了
mon1=subs(dtoc(date()),1,2)+subs(dtoc(date()),4,2)
select serv.w_no, worker.emp_nm, count(*) as get_ct;
from serv, worker;
where serv.w_no = worker.w_no and;
not empty(serv.serv_date) and;
(subs(dtoc(serv_date),1,2)+subs(dtoc(serv_date),4,2)=subs(mon1,1,2)+subs(mon1,3,2) or ;
subs(dtoc(serv_date2),1,2)+subs(dtoc(serv_date2),4,2)=subs(mon1,1,2)+subs(mon1,3,2));
group by serv.w_no;
order by 1;
into cursor bba

[janlih]

參考 set enginebehavior 70
預設為 set enginebehavior 90

[impotence]

看樣子 .. 應該是 group by 的原因 ....
請看一看 , VFP9 的 help .....