Hello,

I have two FPW2.6 tables, TableA and TableB. I am trying to copy records from one table to the other table. Several records in TableB are marked for deletion.

When I issue the command APPEND FROM TABLEB FOR !DELETED(), all of the records are appended to TableA regardless of their deleted status. Any idea why this command will not work?

If I issue the command COPY TO TEMP FOR !DELETED(), the correct records are copied to the Temp.dbf. I do not see the difference in the FOR clause that would permit one command to work and one not to work.

Thanks,