replace ty2010 with NVL(AcrsYTD.YTD,0) && - no error message anymore>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)&&error message > endif > lnRecno = lnRecno + 1 >ENDSCAN >>>>HI,