为什么ADODataSet post提交会出错?
我是用如下的语句在SQLserver中选出数据:
SELECT W.ID, W.TreeParent, W.UserCode, W.Name, W.ShortName, W.PinYin, W.Model, W.Spec, W.Area, W.Type, W.Unit, W.Unit2, W.Scale, W.Sort, W.BarCode, W.Pos_Price, W.Pos_Purch, W.ConstPrice, W.Price1, W.Price2, W.Price3, W.Price4, W.Up_Limit, W.Down_Limit, W.Memo, W.[Use], W.Mode, IsNull(Sum(WS.Number),0) AS SumNumber, IsNull(Sum(WS.Total),0) AS SumTotal FROM Ware AS W LEFT JOIN WareStock AS WS ON W.ID = WS.WareID GROUP BY W.ID, W.TreeParent, W.UserCode, W.Name, W.ShortName, W.PinYin, W.Model, W.Spec, W.Area, W.Type, W.Unit, W.Unit2, W.Scale, W.Sort, W.BarCode, W.Pos_Price, W.Pos_Purch, W.ConstPrice, W.Price1, W.Price2, W.Price3, W.Price4, W.Up_Limit, W.Down_Limit, W.Memo, W.[Use], W.Mode
并使用DBEDit控件编辑后,为什么提交的时候会提示:
缺少更新或刷新的基本表消息
但是这个程序使用access的时候就没有问题!!!!