If SET DELETED is OFF during an APPEND FROM, deleted records will also be appended but the deletion mark will not be present in the appended records.

>There are no stored procedures in the database to set primary key. When I got this error, I checked the cursor obtained by SPT "Select * " from the source table and it actually has duplicate records in it, while the source table does not have any duplicates. I only discovered these duplicates when it tried to append the records into the copy table and the primary key index caught the dups. Successive runs get dups in different tables or different records of the same table. What is really weird about this is when I create RV's for each table in the DBC using select * and use the same code with the RV's in place of the SPT cursor, it get all records with no duplicates. This only happens with SPT and Select *. Joel mentioned fetch in background setting might be causing SPT to screw up the fetch, so I will try to change that to see.