>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