You mey be better served with an UPDATE SQL
UPDATE Table
SET field = b.value
where a.Search = b.key



>I friend of mine did a program as below and complains
>scan is too low.
>He as 3,000,000 records
>He wonder if the struct is correct or is there a better way
>to do that.
>Tables are into a database
>
>sele tabela A
>set order to indice
>sele tabela B
>go top
>scan
>sele tabela A
>seek(tabela B.campo)
>if found()
>replace value from tabelaB to tabelaA
>sele tabela B
>endif
>endscan