数据窗口的问题???急
我在数据窗口修改数据时,如果一次只更新修改一个记录保存则一切正常,可是当我一次更改多条记录在保存时总是出现数据错误的消息,内容如下:
Row changed between retrieve and update.
No changes made to database.
UPDATE tab_hmz SET Fcfx = 1 WHERE Cz = 10010 AND Hccz = 'C62 ' AND Hcch = 5 AND Ddfx IS NULL AND Ddcc = '111 ' AND Ddyrsf = {ts '2002-02-21 16:30:00.000000'} AND Dryrsf IS NULL AND Zywyrsf IS NULL AND Zxzx IS NULL AND Bzbh = 21 AND Fcfx = 0 AND Fccc IS NULL AND Fcrysf IS NULL AND Zyzl IS NULL AND Fyyc_zryrsf IS NULL AND Fyyc_zcyrsf IS NULL AND Fyyc_tlsf IS NULL AND Js IS NULL AND Hwmc = 4000 AND Drzxyrsf IS NULL AND Zyxzywyrsf IS NULL AND Zyzl_new = 1
我也不知道问题出在那里。我这个数据窗口的所针对的表有一个完整性约束的出发器内容是:
create trigger trg_hmz_update on tab_hmz for update
as if exists(select count(*) from tab_hmz group by
Cz,Hcch,Ddyrsf having count(*) > 1) rollback
transaction else commit transaction
请帮我诊断一下,我该从那里下手,我不知道是我在PB的代码问题,还是数据库的问题。谢谢