>I need to copy my DBF to an ascii text file and recover it later on.
>
>The method i am using now is COPY TO (filename) type deli
>
>and then APPEND FROM (filename) using an empty table structure.
>
>However the deleted records are not being marked as deleted in the ascii file.
>
>How do I COPY TO / APPEND FROM to take care of the deleted records
>
>OR
>
>is there another way altogether
If you need it in a text file:
ALTER TABLE myTable ADD COLUMN lDeleted
REPLACE ALL lDeleted WITH DELETED()
COPY TO output.txt DELI
APPEND FROM output.txt DELI
DELETE ALL FOR lDeleted
ALTER TABLE myTable DROP COLUMN lDeleted