>HI,
>
>i try add newfileld T.ID # 0 as below i get error message Field "ty2010" does not accept null values
>
>and i need to T1.Nam = T.Nam get exactly nam , i try set exact on and == but not work
>
>

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.Name = crsYTD.Nam

See the change I made here - used NVL function.

Comment out this code bellow - why do you need it?

>local lnRecNo
>lnRecno = 1
>select NewTest
>scan 
>if between(m.lnRecno, 1, reccount('crsYTD'))
>
>   goto lnRecno in crsYTD
>   replace ty2010 with crsYTD.YTD &&error message Field "ty2010" does not accept null values 
>   endif
>   lnRecno = lnRecno + 1
>ENDSCAN
>

>thanks
>>>Is Name + Month combination unique? yes
>>>And each Name repeats for each month?yes
>>
>>One approach - not good performance
>>

>>   select T.Nam, T.ID1, (select sum(Y2010) as YTD from NewTest T1 where T1.Nam = T.Name and T1.ID1 <= T.ID1) as YTD from 
>>   NewTest T into cursor crsYTD
>>

>>Second approach I already wrote in my other message - use scan and intermediate cursor.