>I need to append from a table only those records I have not appended before. I have a unique field but just cannot find the proper way to do this.
>I have to append data from 3 remote locations into a local table daily
>without duplicating these records
>any ideas?
>thanks in advance..
>Dave Carter
You can use a SQL select to get the records you haven't previously appended and then append them from your temporary cursor.
select * from mytable where mytable.uniqueID not in ;
(select uniqueID from targettable) into cursor c_temp
select targettable
append from dbf("c_temp")
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao