我的数据在dw中检索出来后,修改了保存不了!!
提示:
Row changed between retrieve and update.
No changes made to database.
UPDATE kh_ddhz SET biaoshi = '已上传' WHERE fd = '五洲城店' AND shky = 'lml' AND lshh = 'lsh200909030020' AND dd_jhrq = '2009-08-21' AND dd_jhshj IS NULL AND dd_dhrq = '2009-09-03' AND dd_dhshj = '16:03:05' AND shfs IS NULL AND hykh = '' AND khmch = '513' AND tel = '321862' AND address = '3' AND zqfd = '五洲城店' AND sshje = 4.50 AND dje = 0.10 AND qje = 4.40 AND is_qh IS NULL AND is_qk = '自取' AND biaoshi = '未上传' AND beizhu = '88888888888888'
这是怎么回事啊?!!
------解决方案--------------------
1、建表时把字段设为不能为空,或没设主键
2、也许update properties中的Unique Key Columns設置有問題
3、数据库有可能被锁住
4、KEY MODIFICATION属性改为 USE DELETE THEN INSERT
5、在数据窗口做UPDATE处理的时候要及时COMMIT或ROLLBACK,来结束当前处理记录
------解决方案--------------------
Row changed between retrieve and update.
在你修改数据的时候,是不是还有别人在修改,并且比你先做了保存
------解决方案--------------------
可以改一下update的参数试试