数据库中其中三个字段分别为je,yf,zje
现在想让zje自动计算出来。我用了creat a computed field,公式为 je+yf
可计算出来的数据怎么存到zje中去啊
datawindow的itemchanged事件
double ld_je,ld_yf,ld_zje
choose case lower(dw_1.getcolumnname())
case "je"
ld_je = double(this.gettext())
if isnull(ld_je) then ld_je = 0
ld_yf = double(this.getitemnumber(row,yf))
if isnull(ld_yf) then ld_yf = 0
ld_zje = ld_je + ld_yf
case yf
ld_yf = double(this.gettext())
if isnull(ld_yf) then ld_yf = 0
ld_je = double(this.getitemnumber(row,je))
if isnull(ld_je) then ld_je = 0
ld_zje = ld_je + ld_yf
end choose
this.setitem(row,zje,ld_zje)