2,727
社区成员
发帖
与我相关
我的任务
分享
Create Database MyData.Dbc && 建立一个数据库
Create Table bqks.Dbf (Id i,cj i) && 建立一个表
Create Trigger On bqks For Update As Myupd()
*-- vfp6.0
Procedure Myupd()
Select Nvl(Avg(cj),0) As cj_avg Into Cursor t1 From bqks Where Id<>0
Update bqks Set cj=t1.cj_avg Where bqks.Id=0
Endproc
*-- vfp9.0
*!* Procedure Myupd()
*!* Update bqks Set cj=b.cj_avg From (Select Nvl(Avg(cj),0) As cj_avg From bqks Where Id<>0) b Where bqks.Id=0
*!* Endproc
不过,你的问题用触发器行不通,因为这段代码运行有问题,你试着运行: