Hi Ajay,

The following is what I did, However it doesn't check the duplicate record.
Also the code works for the first time when both temp and annual database are empty. But when the second time come, where temp database now contain duplicate records for each record (double the size). And the code didn't check for dup, instead it just append all the records from temp database into annual database.

Any ideas!!!


select temp

APPEND FROM d:\dean\ftp.txt TYPE delimited with |

select annual
set order to lastname


select temp
scan
if !seek(f_fname+f_lname, "annual")
scatter fields like * to t_array
select annual
append from array t_array
release t_array
else
exit
endif
endscan