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