datawindow数据不能更新问题

[天地不仁以万物为刍狗]

我更改了数据窗口了的一行数据中的某一项
按提交后保存 用
if dw_1.update()=1 then
row = dw_1.getrow( )
WORK_RECORD_ID = dw_1.getitemnumber( row,'WORK_RECORD_ID')
SID = dw_1.getitemnumber( row,'WORK_RECORD_SID')
WORK_RECORD_COMPANY = TRIM(dw_1.getitemstring( row,'WORK_RECORD_COMPANY'))
WORK_RECORD_AREA_SHENG = TRIM(dw_1.getitemstring( row,'WORK_RECORD_AREA_SHENG'))
WORK_RECORD_AREA_SHI = TRIM(dw_1.getitemstring( row,'WORK_RECORD_AREA_SHI'))
WORK_RECORD_HEADSHIP = TRIM(dw_1.getitemstring( row,'WORK_RECORD_HEADSHIP'))
WORK_RECORD_ZHICHENG = TRIM(dw_1.getitemstring( row,'WORK_RECORD_ZHICHENG'))
WORK_RECORD_HEADSHIP_LEVEL = TRIM(dw_1.getitemstring( row,'WORK_RECORD_HEADSHIP_LEVEL'))
WORK_RECORD_ZHICHENG_LEVEL = TRIM(dw_1.getitemstring( row,'WORK_RECORD_ZHICHENG_LEVEL'))
WORK_RECORD_HOLD_DATE = date(dw_1.GetItemDateTime( row, 'WORK_RECORD_HOLD_DATE'))
WORK_RECORD_DIMISSION = date(dw_1.GetItemDateTime( row, 'WORK_RECORD_DIMISSION'))

update WORK_RECORD set AREA_SHENG =:WORK_RECORD_AREA_SHENG,AREA_SHI =:WORK_RECORD_AREA_SHI,HEADSHIP=:WORK_RECORD_HEADSHIP,HEADSHIP_LEVEL=:WORK_RECORD_HEADSHIP_LEVEL,ZHICHENG=:WORK_RECORD_ZHICHENG,ZHICHENG_LEVEL=:WORK_RECORD_ZHICHENG_LEVEL,HOLD_DATE=:WORK_RECORD_HOLD_DATE,DIMISSION=:WORK_RECORD_DIMISSION
where ID = :WORK_RECORD_ID;
commit;
else
rollback;
messagebox("提示","提交失败!")
END IF

出现了 DataWindow does not have UPDATE capability 的错误提示 就是提交之后数据库没有变化啊
怎么回事啊
把if dw_1.update()=1 then 判断去掉出现了
Application terminated
Error:Invalid DataWindow roe/column specified at line 9 in clicked event of object cb_tijiao of w_lvli
就是提交之后数据库没有变化啊 还有错

[zjntche_cn]

根据错误信息可知：在object cb_tijiao of w_lvli的Clicked事件的第9行出现了无效的行或者列！

[天地不仁以万物为刍狗]

dw_1.update()
我感觉是这句话的问题
因为执行到这句就跳到else了
dw_1.update()提示 DataWindow does not have UPDATE capability

[zjntche_cn]

dw_1没有更新的权限？瞧瞧你那个dw_1的update properties吧！

[lovelihp]

楼上的正解

[pb8]

TRIM(dw_1.getitemstring( row,'WORK_RECORD_ZHICHENG'))
字段名写错了，看看数据窗口里面它的名字
如果没有if,,不走这一段代码当然不会报错