hi all,
it works as under ,

scan
SELECT aa2005.no,aa2005.salar,thred2.no,thred2.salar FROM aa2005,thred2 WHERE aa2005.no=thred2.no;
into cursor curdummy nofilter
replace thred2.salar WITH curdummy.salar_a FOR thred2.no=curdummy.no_a
endscan
skip

>hi,
>i try as under i got one field replacment only, any idea
>

>SELECT aa2005.no,aa2005.salar,thred2.no,thred2.salar FROM aa2005,thred2 WHERE aa2005.no=thred2.no
>scan
>replace thred2.salar WITH salar_a FOR thred2.no=aa2005.no
>endscan
>

>thanks
>>hi all,
>>any idea help.
>>i try to replace field with another filed where field1=field2
>>as under but something rong.
>>

>>close all
>>use thred2 in 0
>>index on no to kk
>>use aa2005 in 0
>>index on no to kk1
>>scan
>>replace thred2.salar with aa2005.salar for aa2005.no=thred2.no
>>endscan
>>