UPDATE X1 ;
SET AddressCoefficient = IIF(X1.Address IN (SELECT Address FROM X1 WHERE !EMPTY(Address) GROUP BY Address HAVING COUNT(*) > 1), 0.1, 0)

对X1表中的AddressCoefficient 字段进行更新，使用了IIF函数，这里X1.Address IN (SELECT Address FROM X1 WHERE !EMPTY(Address) GROUP BY Address HAVING COUNT(*) > 1) 是不是不能作为判断条件？？一直提示缺少逗号(,)

VFP中不能这么用吧

Create Curs x1(add1 c(20),Coefficient i Null Default Null)
Insert Into x1(add1) Values('aa')
Insert Into x1(add1) Values('aa')
Insert Into x1(add1) Values('bb')
Insert Into x1(add1) Values('bb')
Insert Into x1(add1) Values('cc')
Insert Into x1(add1) Values('cc')
Insert Into x1(add1) Values('dd')

Update t1 Set t1.Coefficient=Iif(Isnull(t2.add1),0,1) From x1 As t1 ;
    left Join (Select add1,Count(*) As nt From x1 Group By add1 Having Count(*)>1) As t2 On t2.add1=t1.add1

sele x1
browse

VFP中貌似不能这么用
3楼方案可行，逻辑也清晰
把需要用SQL加工的数据集做成查询或临时表，然后按条件更新即可

[此贴子已经被作者于2024-4-9 07:54编辑过]

收到，谢谢

高！