hi,

select T.ID,T.Nam, T.ID1, (select sum(Y2010) as YTD from NewTest T1 WHERE   T1.ID#0  AND T1.Nam = T.Nam and T1.ID1 <= T.ID1 ) as YTD from ;
   NewTest T into cursor crsYTD
     
   update NewTest set ty2010 = NVL(YTD,0) ;
         from NewTest inner join crsYTD YTD on NewTest.ID1 = NewTest.ID1 and NewTest.Nam = crsYTD.Nam

BROW&&work

local lnRecNo
lnRecno = 1
select NewTest
scan 
if between(m.lnRecno, 1, reccount('crsYTD'))

   goto lnRecno in crsYTD
   replace ty2010 with AcrsYTD.YTD&&same error message
   endif
   lnRecno = lnRecno + 1
ENDSCAN

>>HI,
>>
>>i get the same error,
>>i need this code to replace newtest.ty2010 with (AcrsYTD.YTD)
>>
>>
>
>Post your current code. Did you apply NVL function where appropriate?