对DBF文件统计的问题,老提示SQL语法错!麻烦大家过来帮我看看是什么问题!谢了先
写了一个游标,不过老是提示 SQL语法错误。
具体错误如下:
[Microsoft][ODBC Visual Foxpro Driver]Syntax error!
具体代码如下:
string ls_dq
long ll_sum_dqrs
declare bkrs_cur cursor for
SELECT dq, SUM(cou_dq) AS sum_dqrs
FROM (SELECT dq, zy, COUNT(dq) AS cou_dq
FROM bmk
GROUP BY dq, zy
HAVING (zy >= 2000000)) DERIVEDTBL
GROUP BY dq
ORDER BY dq;
open bkrs_cur;
Fetch bkrs_cur Into :ls_dq, :ll_sum_dqrs;
do while sqlca.sqlcode = 0
Fetch bkrs_cur Into :ls_dq, :ll_sum_dqrs;
loop
close bkrs_cur;