A Row changed between retrieve and update.

No changes made to the database.

The 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"=?

CodePudding user response:

Generally there are three reasons:
1. The where clause... Has not been set to the Key Columns: only use keywords as a symbol of the whole record, (second line updating a nullable Columns and cause)
2. Update set way into Use Update: modify directly, rather than Use the Delete then Insert: first Delete, Insert again, (when cross modifying data, unlikely)
3. If wrong, update, database data and retrieval, impossible (basic)

CodePudding user response:

The

refer to the original poster gulur response:

Row changed between retrieve and update.

No changes made to the database.

The 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"=?

The update properties in the where clause for update/delete set to Key Columns to try

CodePudding user response:

With reference to two try upstairs, should be updated attribute set is not correct

CodePudding user response:

I also met the same problem, however, my concern is:

The Use the Delete then Insert, it will not change the original line ID?