不能更新临时表?
select 单位,个人编号,退休时间,姓名,身份证号码,count(*) as rs from xxb group by 退休时间,单位,姓名 where 退休时间>=uqs and 退休时间<=uzz into curs tzd
select 单位,个人编号,退休时间,姓名,身份证号码,sum(rs) as hjrs from tzd group by 退休时间,单位 having count(*)>1 into curs utzd
sele tzd
scan
update tzd set rs=utzd.hjrs where tzd.退休时间=utzd.退休时间 and tzd.单位=utzd.单位
endscan
[解决办法]
select 单位,个人编号,退休时间,姓名,身份证号码,count(*) as rs from xxb group by 退休时间,单位,姓名 where 退休时间>=uqs and 退休时间<=uzz into curs tzd READWRITE NOFI
[解决办法]
要加上 READWRITE 关键字