请问:按同字段不同值导出为excel表格,会出现每次查询结果窗口需要逐个关闭,怎么取消窗口提示
set safety offclose all
local bmc
select xqdm,count(*) rs from cj.dbf group by xqdm into cursor xx
select xx
scan
bmc = alltrim(xqdm)+"-"+transform(rs)+"条数据"
* select * from cj.dbf where alltrim(cj.xqdm) == alltrim(xx.xqdm) into table &bmc
select * from cj.dbf where alltrim(cj.xqdm) == alltrim(xx.xqdm)
copy to &bmc type xl5
endscan
close all
cj.zip
(262 Bytes)