update ListsaleDFT se where List_ID = @P1 and Bill_ID = @P2 这是用sql事件跟踪抓的sql语句,感觉很奇怪
exec sp_executesql N'update Sys_Fields set FieldName = @P1, FieldLength = @P2 where FieldName = @P3 and FieldDesc = @P4 and FieldLength = @P5 and DefaultValue is null and CreateDate = @P6 ', N'@P1 varchar(20),@P2 int,@P3 varchar(20),@P4 varchar(40),@P5 int,@P6 datetime', 'ActiveRightV', 101, 'ActiveRight', '权限值', 10, '08 2 2012 5:09PM'我踪了下我的三层出来的语句。ListsaleDFT se where 分析下问题原因: //---这里没有出来修改的列及值,你可以用二层+ClientDataSet模拟下三层更新看看能否成功。 //--- List_ID = @P1 and Bill_ID = @P2 另你的表只有这两个列的? 看看是否有什么属性被修改过了DataSetProvider控件的。
其它的表也会出现问题 我跟踪的语句就是出现se按理来说应该是set后边跟着更新的字段
update ListsaleDFT se where AutoID = @P1 and List_ID = @P2 and Bill_ID = @P3 and Stor_ID = @P4 and Prod_ID = @P5 and Prod_Number = @P6 and Prod_ProdDw = @P7 and Prod_Price = @P8 and Prod_Money = @P9 and Discount = @P10 and DisPrice = @P11 and DisMoney = @P12 and DisMoney0 = @P13 and Tax = @P14 and TaxPrice = @P15 and TaxMoney = @P16 and TaxMoney0 = @P17 and Re is null and SerNumber is null and OutFactoryDate is null and DZYH_Date is null and Prod_Order = @P18 and pDW_Ratio = @P19 and pDW_Num = @P20 and CostPrice = @P21 and CostMoney = @P22 and InorOut = @P23 and Prod_DDID = @P24 and tmpSyb = @P25 and TeamNo = @P26 and DZSign = @P27 and ZS_Syb = @P28 and MutilCode is null and DiffMoney = @P29 and JSMoney = @P30 and WriteJSBill = @P31 and ZeroSyb = @P32 and Promotion is null and UseVIPSyb = @P33 and DWRatio = @P34 and ProdQuantity = @P35 and DWRatio1 is null and Assistant1 is null and DWRatio2 is null and Assistant2 is null and Re1 is null and Re2 is null and Re3 is null and seUnitName is null and Prod_SeNumber = @P36 and prod_FactNumber = @P37 我重新跟踪了下这个语句
where
List_ID = @P1 and
Bill_ID = @P2
这是用sql事件跟踪抓的sql语句,感觉很奇怪
FieldName = @P1,
FieldLength = @P2
where
FieldName = @P3 and
FieldDesc = @P4 and
FieldLength = @P5 and
DefaultValue is null and
CreateDate = @P6
', N'@P1 varchar(20),@P2 int,@P3 varchar(20),@P4 varchar(40),@P5 int,@P6 datetime', 'ActiveRightV', 101, 'ActiveRight', '权限值', 10, '08 2 2012 5:09PM'我踪了下我的三层出来的语句。ListsaleDFT se
where
分析下问题原因:
//---这里没有出来修改的列及值,你可以用二层+ClientDataSet模拟下三层更新看看能否成功。
//---
List_ID = @P1 and
Bill_ID = @P2
另你的表只有这两个列的?
看看是否有什么属性被修改过了DataSetProvider控件的。
我跟踪的语句就是出现se按理来说应该是set后边跟着更新的字段
where
AutoID = @P1 and
List_ID = @P2 and
Bill_ID = @P3 and
Stor_ID = @P4 and
Prod_ID = @P5 and
Prod_Number = @P6 and
Prod_ProdDw = @P7 and
Prod_Price = @P8 and
Prod_Money = @P9 and
Discount = @P10 and
DisPrice = @P11 and
DisMoney = @P12 and
DisMoney0 = @P13 and
Tax = @P14 and
TaxPrice = @P15 and
TaxMoney = @P16 and
TaxMoney0 = @P17 and
Re is null and
SerNumber is null and
OutFactoryDate is null and
DZYH_Date is null and
Prod_Order = @P18 and
pDW_Ratio = @P19 and
pDW_Num = @P20 and
CostPrice = @P21 and
CostMoney = @P22 and
InorOut = @P23 and
Prod_DDID = @P24 and
tmpSyb = @P25 and
TeamNo = @P26 and
DZSign = @P27 and
ZS_Syb = @P28 and
MutilCode is null and
DiffMoney = @P29 and
JSMoney = @P30 and
WriteJSBill = @P31 and
ZeroSyb = @P32 and
Promotion is null and
UseVIPSyb = @P33 and
DWRatio = @P34 and
ProdQuantity = @P35 and
DWRatio1 is null and
Assistant1 is null and
DWRatio2 is null and
Assistant2 is null and
Re1 is null and
Re2 is null and
Re3 is null and
seUnitName is null and
Prod_SeNumber = @P36 and
prod_FactNumber = @P37
我重新跟踪了下这个语句