PB编程错误Row changed between retrieve and update. No changes made to database.

[gulur]

Row changed between retrieve and update.

No changes made to database.

DELETE FROM "zbfxb" WHERE "qj" = ? AND "zbzl_bm" = ? AND "zblb_code" = ? AND "zb_bm" = ? AND "zbxz_code" = ? AND "jsff" = ? AND "dw_code" = ? AND "zbz" = ? AND "qzz" = ? AND "sdxs" = ? AND "bdxs" = ? AND "sdbzz" = ? AND "bdbzz" = ? AND "gxxs" = ? AND "zbdf" = ? AND "xzxs" = ? AND "bz" = ?

[做梦的猫]

一般有三种原因： 1. where clause ... 没有被设置为 Key Columns：仅仅使用关键字作为整条记录的标志。（二次更新某行可为空的列时会引发） 2. 更新方式设置成了 Use Update：直接修改，而不是 Use Delete then Insert：先删除,再插入。（当数据被交叉修改时会引发，可能性不大） 3. 如错误所说，执行更新时，数据库的数据与检索时不同。（基本不可能）

[WorldMobile]

引用 楼主 gulur 的回复:

Row changed between retrieve and update. No changes made to database. DELETE FROM "zbfxb" WHERE "qj" = ? AND "zbzl_bm" = ? AND "zblb_code" = ? AND "zb_bm" = ? AND "zbxz_code" = ? AND "jsff" = ? AND "dw_code" = ? AND "zbz" = ? AND "qzz" = ? AND "sdxs" = ? AND "bdxs" = ? AND "sdbzz" = ? AND "bdbzz" = ? AND "gxxs" = ? AND "zbdf" = ? AND "xzxs" = ? AND "bz" = ?

把update属性里 where clause for update/delete设置为Key Columns试试

[fengxiaohan211]

参照楼上的两位试试吧。应该是更新属性的设置不正确

[FrankLiang]

我也遇到 同样问题，不过，我担心的是： 用了Use Delete then Insert， 那原行的ID会不会改变？