Is there such a strange thing? ? !! !! Anxious, expert help

bingqing

I can't perform "
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 ", but it can be executed in SQL. Please help experts

entwine

convert (numeric (20,4), a.xykc * jhdj)--1 * 17
It is better to put brackets in some places
Is the burden reduced by 1 * 17?
The same statement will be executed in SQL execution VB

bingqing

Are the brackets the same? It's wrong to add brackets

likepaopao

dizzy.
Never tried this update

bingqing

Prompted by zero division error, but I checked the database a.xykc = 0, jhdj = 17

shitgeb

Write in VB:
Data source.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 "
It should be possible, I often write UPdate like this, to ensure that (a.xykc- (-1)) <>0