数据更新问题**

vincent

我改了数据集的select 语句..更新的时候就报错..请问有什么好办法无?
SELECT
PREPAYNOTICEID, CASEGUID, PAYCOMPANY,
   LICENCEID, BILLCREATEDATE, ENGROSSTEMPROAD,
   Round(ENGROSSTEMPMONEY,8) ENGROSSTEMPMONEY,  Round(MONEYTOTAL,8) MONEYTOTAL, PREPAYNOTICECHECKER,
   PREPAYNOTICEMAKER, PREPAYNOTICEADDRESS, PREPAYNOTICEPHONE,
   LASTUPDATEUSER, CREATEDATE, CREATEUSER,
   LASTUPDATEDATE, PAYLIMITDATE
FROM TBLPREPAYBILLOCCUPY

atiger

啥错误呢？把原始的错误信息贴出来看看

vincent

invoke batch method error, error occur during invoke ApplyUpdates method, 当前修改的数据已经被其他用户修改，不能进行保存操作. SQL:UPDATE TBLPREPAYBILLOCCUPY SET PrePayNoticeChecker=?, CreateDate=?, LastUpdateDate=?  WHERE PrePayNoticeID = ?  AND CaseGUID = ?  AND PayCompany = ?  AND LicenceID = ?  AND BillCreateDate = ?  AND EngrossTempRoad = ?  AND ENGROSSTEMPMONEY = ?  AND MONEYTOTAL = ?  AND PrePayNoticeChecker = ?  AND PrePayNoticeMaker = ?  AND PrePayNoticeAddress = ?  AND PrePayNoticePhone = ?  AND LastUpdateUser = ?  AND CreateDate is NULL AND CreateUser = ?  AND LastUpdateDate = ?  AND PayLimitDate = ?

zfang

看看数据集的更新选项，更新条件选择主键看看。

zfang

http://bbs.justep.com/forum.php?mod=viewthread&tid=25219

shangxy

楼主问题怎么样了？