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
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
>