求助:如何将一个 dbf 按某个字段分成多个 dbf
字段是文字,而不是数字,比如是学校名称。需要根据学校名称拆分成多个dbf,每个学校一个。想要一次性实现,而不是用copy to 一个一个生成。万分感谢啊!
set safety off close all select distinct xymc from 示例表格 into cursor xx scan select * from 示例表格 where alltrim(xymc) == alltrim(xx.xymc) into table alltrim(xx.xymc) endscan close all quit
set safety off close all select distinct xymc from 示例表格 where len(alltrim(xymc))>0 into array xmc nNum = ALen(xmc,0) For i = 1 TO nNum select * from 示例表格 where alltrim(xymc)==alltrim(xmc(i)) into table (xmc(i)) endfor close all quit
[此贴子已经被作者于2022-3-28 06:01编辑过]