有这种怪事？？！！急，高手帮忙

bingqing

我在VB中不可以执行“
update spmsb set jhdj=(convert(numeric(20,4),a.xykc*jhdj)- -1*17)/(a.xykc- -1) from spmsb,
(select spkcb.spidh as spidh,sum(xykc) as xykc from SPKCB,spmsb
where SPKCB.spidh=spmsb.spidh and  spkcb.spidh=3158 group by spkcb.spidh) a
Where spmsb.spidh = a.spidh”该语句，但在SQL中就可以执行。请各位高手帮帮忙

entwine

convert(numeric(20,4),a.xykc*jhdj)- -1*17
有的地方最好加上括号
是减负1*17?
同样的语句SQL中执行VB中是会执行的

bingqing

有没有括号是一样的，加了括号也不对啊

likepaopao

好暈。
沒試過這樣update

bingqing

提示被零除错误，但是我查看了数据库a.xykc=0,jhdj=17

shitgeb

VB中写：
数据源.Execute "update spmsb  set jhdj=(convert(numeric(20,4),a.xykc*jhdj)- (-1*17))/(a.xykc- (-1)) from spmsb
inner join (select spkcb.spidh as spidh,(case when sum(xykc)=-1 then 0 else sum(xykc)  end )as xykc   from SPKCB inner join spmsb
on  SPKCB.spidh=spmsb.spidh and  spkcb.spidh=3158 group by spkcb.spidh) a
on spmsb.spidh = a.spidh "
应该可以的 ，我经常这样写UPdate，要保证 (a.xykc- (-1)) <>0的