同时查询多表更新的问题
zqycn 2011-05-10 12:05:16 select a.resultid, a.rdate,a.sampleid,a.IID,a.itemTypeID,a.sambtype,a.Item,a.sState AS exce,a.iState,a.iValue,a.sValue,conc=case len(isnull(a.sValue, ' ')) when 0 then convert(char,a.iValue) else a.sValue end,isnull(convert(decimal(9,2),b.iRLow),0) as iRLow,isnull(convert(decimal(9,2),b.iRhigh),0) as iRhigh
from result a,item b
where a.Tid=b.TID and a.item=b.item
如上 这样一条sql语句得到的数据集,DBGrid显示主要显示a.item,value
我可否在dbgrid中修改value值,后令ivalue或svalue=此值 然后通过数据集的方法更新修改