从数据集保存报错**

liso

主数据集与从数据集来自于数据库里同一个表，从数据集保存时会计算合计数保存到主数据集。现在主数据集新增保存都没问题，而从数据集新增也没问题，保存时报以下错。

invoke batch method error, error occur during invoke ApplyUpdates method, 当前修改的数据已经被其他用户修改，不能进行保存操作. SQL:declare @A0 nvarchar(3) select @A0=? declare @A1 nvarchar(1) select @A1=? declare @A2 nvarchar(34) select @A2=? declare @A3 nvarchar(34) select @A3=? declare @A4 nvarchar(30) select @A4=? declare @A5 numeric(8,3) select @A5=? declare @A6 nvarchar(32) select @A6=? declare @A7 numeric(8,0) select @A7=? declare @A8 numeric(8,3) select @A8=? declare @A9 nvarchar(32) select @A9=? declare @A10 nvarchar(32) select @A10=? declare @A11 nvarchar(32) select @A11=? declare @A12 nvarchar(32) select @A12=? declare @A13 nvarchar(32) select @A13=? declare @A14 nvarchar(32) select @A14=? declare @A15 numeric(8,3) select @A15=? declare @A16 nvarchar(32) select @A16=? declare @A17 nvarchar(2) select @A17=? declare @A18 nvarchar(32) select @A18=? declare @A19 numeric(8,3) select @A19=? declare @A20 nvarchar(32) select @A20=? declare @A21 numeric(8,3) select @A21=? declare @A22 numeric(8,3) select @A22=? declare @A23 nvarchar(24) select @A23=? declare @A24 nvarchar(32) select @A24=? declare @A25 nvarchar(32) select @A25=? declare @A26 nvarchar(32) select @A26=? declare @A27 numeric(8,0) select @A27=? declare @A28 nvarchar(1) select @A28=? declare @A29 nvarchar(3) select @A29=? declare @A30 nvarchar(1) select @A30=? declare @A31 nvarchar(34) select @A31=? declare @A32 nvarchar(34) select @A32=? declare @A33 nvarchar(30) select @A33=? declare @A34 nvarchar(32) select @A34=? declare @A35 nvarchar(32) select @A35=? declare @A36 nvarchar(32) select @A36=? declare @A37 nvarchar(32) select @A37=? declare @A38 nvarchar(32) select @A38=? declare @A39 nvarchar(32) select @A39=? declare @A40 nvarchar(32) select @A40=? declare @A41 nvarchar(32) select @A41=? declare @A42 nvarchar(2) select @A42=? declare @A43 nvarchar(32) select @A43=? declare @A44 nvarchar(32) select @A44=? declare @A45 nvarchar(32) select @A45=? declare @A46 nvarchar(32) select @A46=? declare @A47 nvarchar(32) select @A47=? declare @A48 nvarchar(32) select @A48=? declare @A49 nvarchar(32) select @A49=? UPDATE NQCONTRACTINFBASE SET ID = @A0 , XSCG = @A1 , SJBH = @A2 , ContractNo = @A3 , GYS = @A4 , CGJE = @A5 , ZDFKSJ = @A6 , WLYFGYSRMBHK_RMB_ = @A7 , WLWFGYSRMBHK_RMB_ = @A8 , BGRQ = @A9 , BGDH = @A10 , HXDH = @A11 , JJCBRQ = @A12 , ZPKPRQ = @A13 , ZPHM = @A14 , ZPJE = @A15 , TSSBRQ = @A16 , TSZT = @A17 , TSRQ = @A18 , TSJE = @A19 , TSGHKHRQ = @A20 , TSGHJERMB = @A21 , TSCE = @A22 , WTR = @A23 , WTRID = @A24 , GYSID = @A25 , HXRQ = @A26 , SDBZ = @A27 , HTBZ = @A28 WHERE ( ID = @A29 ) AND ( XSCG = @A30 ) AND ( SJBH = @A31 ) AND ( ContractNo = @A32 ) AND ( GYS = @A33 ) AND ( ZDFKSJ = @A34 ) AND ( BGRQ = @A35 ) AND ( BGDH = @A36 ) AND ( HXDH = @A37 ) AND ( JJCBRQ = @A38 ) AND ( ZPKPRQ = @A39 ) AND ( ZPHM = @A40 ) AND ( TSSBRQ = @A41 ) AND ( TSZT = @A42 ) AND ( TSRQ = @A43 ) AND ( TSGHKHRQ = @A44 ) AND ( WTR = @A45 ) AND ( WTRID = @A46 ) AND ( GYSID = @A47 ) AND ( HXRQ = @A48 ) AND ( HTBZ = @A49 )

zfang

看看数据集的更新选项--设为主键更新看看。

liso

改过，依然报这个错。

shangxy

看一下从数据集的更新规则是怎么设置的？设置成不做看看。

atiger

楼主，请问，你定义主从关系的时候，设置了，级联更新吗？
或者说，如果你取消主从后，更新现在的从数据集是否正常呢？