hi,
i need your help ,how i can use this code under if i have more than one table have the same field name all of them ,need the same operation as..

select 0
    use newdnc1
    select 0
    use newdnc
    SCAN
        SCATTER MEMVAR
        m.tablechar1=NewDnc.Char1
        SELECT NewDnc1   && newdnc2,newdnc3,newdnc4...etc
        SCAN FOR Char1 == m.tablechar1
             GATHER MEMVAR
        ENDSCAN
        SELECT NewDnc
    ENDSCAN
   CLOSE ALL

thanks.
m.qasem

>What VFP You Use to see this error? If You use VFP 6.0 change RecNo("NewDnc") WITH STR(RecNo("NewDnc"))
>
>Mohammed, did You ever Use a DEBUG to see what happens? Open debug, set a BreakPoint on Locate & see WHY it replace only one record, from a distance it is more difficult to see what happens. Change to this code & see what happens:
>
>

>    select 0
>    use newdnc1
>    select 0
>    use newdnc
>    SCAN
>        SCATTER MEMVAR
>        m.tablechar1=NewDnc.Char1
>        SELECT NewDnc1
>        SCAN FOR Char1 == m.tablechar1
>             GATHER MEMVAR
>        ENDSCAN
>        SELECT NewDnc
>    ENDSCAN
>   CLOSE ALL
>