Updating rows with null value

Hi Guys,

I got a problem like this…

tb:( c1:(1;2); c2:(10;0N))

q)tb

c1 c2


1  10

2    

/ this update suppose to fix the 0N row with the value of the previous row.

/ but for some reason it doesn’t…

q)update c2:c2[i-1] from tb where c2=0N

c1 c2


1  10

2    

any body got an idea how to fix this, appreciate for input

Thanks

Gary

update fills c2 from tb

Terry