Are you sure you have deleted set to OFF?
Alan
>I am trying to append tableA to tableB. Both tables are identical (except tableB has 3 fields that have different character size). My problem is when I do an append from, I need the deleted records to come over along with other records. When I go to view tableB, there are no deleted records, only the non-deleted. Here is the code:
>
>
>use tableB exclusive
>zap
>append from tableA
>
>
>Does anyone know why this might be happening? Is there another way to bring deleted record over if append from doesn't do the job?
>
>Thanks
>Nick Patel