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
>>>>>
>>>>>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
If it's not broken, fix it until it is.
My Blog