Do you need running totals or just a regular replace (update)? If the later, then just use a single update command.

>i need to replace new values at table test,
>i try via previous code
>
>i get only first value from table1 and i stuk at infint loop&& sorry for english words,
>
>i need your help to fix the previous bad code
>
>thanks
>
>>Do you need to solve running total query? If yes, then indeed you need to use scan loop.
>>
>>>thank you for reply
>>>i add for the 2 tables field id and your code it works
>>>
>>>but i need to run it as below
>>>

>>>clea
>>>CLOSE all
>>>USE table1 IN 0
>>>SCAN
>>>m.tot=inctax+addtax
>>>m.penttot=penttot
>>>
>>>USE test IN 0
>>>
>>>IF  nam="tot1"
>>>   SUM y2010 TO m.q
>>>       REPLACE y2010 WITH m.q FOR nam="tot1"
>>>      
>>>       
>>>else       
>>>   replace test.y2010 WITH m.tot
>>>   REPLACE test.column6 WITH m.penttot 
>>>endif 
>>>
>>>IF  nam="tot2"
>>>   SUM y2010 TO m.q
>>>       REPLACE y2010 WITH m.q FOR nam="tot2"
>>>else       
>>>   replace test.y2010 WITH m.tot
>>> REPLACE test.column6 WITH m.penttot 
>>>endif 
>>>
>>>IF  nam="tot3"
>>>   SUM y2010 TO m.q
>>>       REPLACE test.y2010 WITH m.q FOR nam="tot3"
>>>       m.total=tot1+tot2+tot3
>>>       REPLACE test.total WITH m.total
>>>       
>>>else       
>>>    replace test.y2010 WITH m.tot
>>>    REPLACE test.column6 WITH m.penttot 
>>>endif 
>>>
>>>
>>>endscan  
>>>
>>>

>>>thanks
>>>
>>>>>hi all,
>>>>>
>>>>>i need help to get next value from table1 via this code below
>>>>>

>>>>>
>>>>>USE table1 
>>>>>   m.tot=inctax+addtax
>>>>>   m.penttot=penttot
>>>>>
>>>>>USE test
>>>>>Select test
>>>>>SCAN
>>>>>   replace y2010 with m.tot
>>>>>   replace column6 with m.penttot 
>>>>>   
>>>>>**USE table1&&not work
>>>>>
>>>>>ENDSCAN
>>>>>

>>>>>thanks
>>>>
>>>>How these two tables (Test and Table1) are related?
>>>>
>>>>May be you can do just one update command, e.g.
>>>>

>>>>UPDATE Test Set y2010 = T.incTax + T.AddTax, ;
>>>>                  Column6 = T.PentTot 
>>>>                  from Test inner join Table1 T on Test.ID = T.ID