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