Hi Stuzka,
>the append will respect the state of set deleted, sort of. if records are marked deleted and SET DELETED OFF, then all records are copied, and the taget table will maintain the deleted flag. if SET DELETED ON, the deleted recored are not copied at all ( not there ever if changing to SET DELETED OFF ).
What you're saying is exactly the behavior I'm experiencing, but it's the oposite of what is said in the help file! Is the help explanation wrong, and need to be fixed, or it's right and the behavior of the APPEND FROM is wrong (hope not)?
Regards,
Fernando