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
>>>>
>>>>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